DBA Data[Home] [Help]

APPS.AP_WEB_CREDIT_CARD_WF dependencies on PER_ALL_ASSIGNMENTS_F

Line 3132: FROM PER_ALL_ASSIGNMENTS_F ASS,

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

Line 3158: FROM PER_ALL_ASSIGNMENTS_F ASS,

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