DBA Data[Home] [Help]

APPS.PQP_GB_PSI_BON_HISTORY dependencies on PER_ALL_PEOPLE_F

Line 218: from per_all_people_f PER, per_periods_of_service PPS

214:
215: CURSOR csr_start_date
216: IS
217: select PPS.DATE_START -- DECODE(PER.CURRENT_EMPLOYEE_FLAG,'Y',PPS.DATE_START,NULL)
218: from per_all_people_f PER, per_periods_of_service PPS
219: where per.person_id = g_person_id
220: and pps.person_id = g_person_id
221: and p_effective_date between per.effective_start_date
222: and NVL(per.effective_end_date,hr_api.g_eot)