DBA Data[Home] [Help]

APPS.PO_APPROVALLIST_S1 dependencies on PER_PEOPLE_F

Line 573: FROM per_people_f PERF, per_assignments_f PERA1

569: AND pera.person_id = p_employee_id
570: AND pera.primary_flag = 'Y'
571: AND EXISTS
572: (SELECT '1'
573: FROM per_people_f PERF, per_assignments_f PERA1
574: WHERE trunc(sysdate) BETWEEN PERF.effective_start_date
575: AND PERF.effective_end_date
576: AND PERF.person_id = PERA.supervisor_id
577: AND PERA1.person_id = PERF.person_id

Line 681: FROM per_people_f PERF, per_assignments_f PERA1

677: FROM per_assignments_f pera
678: WHERE
679: EXISTS
680: (SELECT '1'
681: FROM per_people_f PERF, per_assignments_f PERA1
682: WHERE trunc(sysdate) BETWEEN PERF.effective_start_date
683: AND PERF.effective_end_date
684: AND PERF.person_id = PERA.supervisor_id
685: AND PERA1.person_id = PERF.person_id