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 3206: PER_PERIODS_OF_SERVICE B2

3202: SELECT P.PERSON_ID, H.SUPERVISOR_ID, H.LVL
3203: FROM PER_PEOPLE_F P,
3204: ( SELECT UNIQUE ass.PERSON_ID,ass.SUPERVISOR_ID, LEVEL -1 LVL
3205: FROM PER_ALL_ASSIGNMENTS_F ASS,
3206: PER_PERIODS_OF_SERVICE B2
3207: WHERE ASS.PRIMARY_FLAG = 'Y' AND ASS.ASSIGNMENT_TYPE = 'E' AND
3208: B2.period_of_service_id = Ass.period_of_service_id AND
3209: B2.DATE_START <= TRUNC(SYSDATE) AND
3210: greatest( NVL(B2.ACTUAL_TERMINATION_DATE, TRUNC(SYSDATE) ) ) between Ass.EFFECTIVE_START_DATE and Ass.EFFECTIVE_END_DATE

Line 3232: PER_PERIODS_OF_SERVICE B2

3228: SELECT P.PERSON_ID, H.SUPERVISOR_ID, H.LVL
3229: FROM PER_PEOPLE_F P,
3230: ( SELECT UNIQUE ass.PERSON_ID,ass.SUPERVISOR_ID, LEVEL -1 LVL
3231: FROM PER_ALL_ASSIGNMENTS_F ASS,
3232: PER_PERIODS_OF_SERVICE B2
3233: WHERE ASS.PRIMARY_FLAG = 'Y' AND ASS.ASSIGNMENT_TYPE = 'E' AND
3234: B2.period_of_service_id = Ass.period_of_service_id AND
3235: B2.DATE_START <= TRUNC(SYSDATE) AND
3236: greatest( NVL(B2.ACTUAL_TERMINATION_DATE, TRUNC(SYSDATE) ) ) between Ass.EFFECTIVE_START_DATE and Ass.EFFECTIVE_END_DATE