DBA Data[Home] [Help]

APPS.PQH_FR_UTILITY dependencies on PER_PERIODS_OF_SERVICE

Line 825: FROM PER_PERIODS_OF_SERVICE PPS1

821: Cursor csr_person_details IS
822: Select per.per_information15, pps.orig_hire_dt
823: from per_all_people_f per,
824: (SELECT min(PPS1.DATE_START) orig_hire_dt
825: FROM PER_PERIODS_OF_SERVICE PPS1
826: WHERE pps1.person_id = p_person_id) pps
827: where per.person_id =p_person_id
828: and trunc(sysdate) between per.effective_start_date and per.effective_end_date;
829: