APPS.PQP_GB_PSI_ALLOWANCE_HISTORY dependencies on PER_ALL_PEOPLE_F

Line 243: from per_all_people_f PER, per_periods_of_service PPS

239:
240: CURSOR csr_start_date
241: IS
242: select DECODE(PER.CURRENT_EMPLOYEE_FLAG,'Y',PPS.DATE_START,NULL)
243: from per_all_people_f PER, per_periods_of_service PPS
244: where per.person_id = g_person_id
245: and pps.person_id = g_person_id
246: and rownum=1
247: order by per.effective_start_date;