APPS.HXC_HXCMISTC_XMLP_PKG dependencies on PER_PEOPLE_F

Line 33: PER_PEOPLE_F PPF

29: PPF.FULL_NAME,
30: NVL(PPF.EMPLOYEE_NUMBER
31: ,PPF.NPW_NUMBER)
32: FROM
33: PER_PEOPLE_F PPF
34: WHERE PPF.PERSON_ID = CP_PERSON_ID
35: AND CP_EFFECTIVE_DATE between PPF.EFFECTIVE_START_DATE
36: AND PPF.EFFECTIVE_END_DATE;
37: CURSOR C_PAYROLL(CP_PAYROLL_ID IN NUMBER,CP_EFFECTIVE_DATE IN DATE) IS

Line 218: from per_people_f

214: L_PERSON_TYPE3 := '(''EMP_APL'',''EMP'',''CWK'')';
215: END IF;
216: END IF;
217: PERSON_TYPE1 := 'and ppf.effective_start_date = (select max(effective_start_date)
218: from per_people_f
219: where person_id = ppf.person_id
220: and effective_start_date <= :p_date_to
221: and effective_end_date >= :p_date_from
222: and ptu.person_id = person_id