DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on PER_ALL_PEOPLE_F

Line 5000: per_all_people_f papf,

4996: hr_organization_units hou, -- Introduced the following tables as part of bug fix 4625734
4997: pa_projects_all ppa,
4998: pa_tasks pt,
4999: per_time_periods ptp,
5000: per_all_people_f papf,
5001: psp_enc_controls pec
5002: WHERE pesl.payroll_action_id = p_payroll_action_id
5003: AND pec.enc_control_id = pesl.enc_control_id
5004: AND pesl.status_code = 'N'

Line 7091: FROM per_all_people_f

7087:
7088: CURSOR get_full_name_cur (p_person_id IN NUMBER,
7089: p_effective_date IN DATE) IS
7090: SELECT full_name
7091: FROM per_all_people_f
7092: WHERE person_id = p_person_id
7093: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
7094: begin
7095: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering LIQUIDATE_EMP_TERM');