APPS.PQP_GB_PSI_STH_HISTORY dependencies on PER_ALL_PEOPLE_F

Line 792: from per_all_people_f PER, per_periods_of_service PPS

788:
789: CURSOR csr_start_date
790: IS
791: select PPS.DATE_START -- DECODE(PER.CURRENT_EMPLOYEE_FLAG,'Y',PPS.DATE_START,NULL)
792: from per_all_people_f PER, per_periods_of_service PPS
793: where per.person_id = g_person_id
794: and pps.person_id = g_person_id
795: and p_effective_date between per.effective_start_date
796: and NVL(per.effective_end_date,hr_api.g_eot)