eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_CREDIT_CARD_WF dependencies on PER_PERIODS_OF_SERVICE

Line 3133: PER_PERIODS_OF_SERVICE B2

3129: SELECT P.PERSON_ID, H.SUPERVISOR_ID, H.LVL
3130: FROM PER_PEOPLE_F P,
3131: ( SELECT UNIQUE ass.PERSON_ID,ass.SUPERVISOR_ID, LEVEL -1 LVL
3132: FROM PER_ALL_ASSIGNMENTS_F ASS,
3133: PER_PERIODS_OF_SERVICE B2
3134: WHERE ASS.PRIMARY_FLAG = 'Y' AND ASS.ASSIGNMENT_TYPE = 'E' AND
3135: B2.period_of_service_id = Ass.period_of_service_id AND
3136: B2.DATE_START <= TRUNC(SYSDATE) AND
3137: greatest( NVL(B2.ACTUAL_TERMINATION_DATE, TRUNC(SYSDATE) ) ) between Ass.EFFECTIVE_START_DATE and Ass.EFFECTIVE_END_DATE

Line 3159: PER_PERIODS_OF_SERVICE B2

3155: SELECT P.PERSON_ID, H.SUPERVISOR_ID, H.LVL
3156: FROM PER_PEOPLE_F P,
3157: ( SELECT UNIQUE ass.PERSON_ID,ass.SUPERVISOR_ID, LEVEL -1 LVL
3158: FROM PER_ALL_ASSIGNMENTS_F ASS,
3159: PER_PERIODS_OF_SERVICE B2
3160: WHERE ASS.PRIMARY_FLAG = 'Y' AND ASS.ASSIGNMENT_TYPE = 'E' AND
3161: B2.period_of_service_id = Ass.period_of_service_id AND
3162: B2.DATE_START <= TRUNC(SYSDATE) AND
3163: greatest( NVL(B2.ACTUAL_TERMINATION_DATE, TRUNC(SYSDATE) ) ) between Ass.EFFECTIVE_START_DATE and Ass.EFFECTIVE_END_DATE