DBA Data[Home] [Help]

APPS.PQP_GB_PSI_SALARY_HISTORY dependencies on PER_ALL_PEOPLE_F

Line 622: from per_all_people_f PER, per_periods_of_service PPS

618: IS
619: CURSOR csr_hire_date
620: IS
621: select PPS.DATE_START --DECODE(PER.CURRENT_EMPLOYEE_FLAG,'Y',PPS.DATE_START,NULL)
622: from per_all_people_f PER, per_periods_of_service PPS
623: where per.person_id = g_person_id
624: and pps.person_id = g_person_id
625: and g_effective_date
626: between per.effective_start_date