The most common examples of this type of event are aging processes. For example, an invoice becomes overdue, an employee reaches his five-year anniversary, or a worklist entry remains unworked for more than a week. PeopleSoft Application Engine enables you to monitor your database for this ...
This is the SQL statement for the [ROLE] Manager query (with the effective date logic removed for simplicity): SELECT C.ROLEUSER FROM PS_JOB A, PS_DEPT_TBL B, PS_ROLEXLATOPR C WHERE B.DEPTID = A.DEPTID AND A.EMPLID = :1 AND C.EMPLID = B.MANAGER_ID The Query Selects Role ...