DBA Data[Home] [Help]

APPS.AP_WEB_CREDIT_CARD_WF dependencies on PER_ALL_ASSIGNMENTS_F

Line 3205: FROM PER_ALL_ASSIGNMENTS_F ASS,

3201: OPEN p_employee_cursor FOR
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

Line 3231: FROM PER_ALL_ASSIGNMENTS_F ASS,

3227: OPEN p_employee_cursor FOR
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