DBA Data[Home] [Help]

APPS.PO_APPROVALLIST_S1 dependencies on PER_PEOPLE_F

Line 591: FROM per_people_f PERF, per_assignments_f PERA1

587: AND pera.primary_flag = 'Y'
588: AND pera.ASSIGNMENT_TYPE IN ('E','C')-- bug 12388225
589: AND EXISTS
590: (SELECT '1'
591: FROM per_people_f PERF, per_assignments_f PERA1
592: WHERE trunc(sysdate) BETWEEN PERF.effective_start_date
593: AND PERF.effective_end_date
594: AND PERF.person_id = PERA.supervisor_id
595: AND PERA1.person_id = PERF.person_id

Line 700: FROM per_people_f PERF, per_assignments_f PERA1

696: FROM per_assignments_f pera
697: WHERE
698: EXISTS
699: (SELECT '1'
700: FROM per_people_f PERF, per_assignments_f PERA1
701: WHERE trunc(sysdate) BETWEEN PERF.effective_start_date
702: AND PERF.effective_end_date
703: AND PERF.person_id = PERA.supervisor_id
704: AND PERA1.person_id = PERF.person_id