DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on PER_ALL_PEOPLE_F

Line 5065: per_all_people_f papf,

5061: hr_organization_units hou, -- Introduced the following tables as part of bug fix 4625734
5062: pa_projects_all ppa,
5063: pa_tasks_expend_v pt, -- Replaced pa_tasks with pa_tasks_expend_v for Bug : 16391366
5064: per_time_periods ptp,
5065: per_all_people_f papf,
5066: psp_enc_controls pec
5067: WHERE pesl.payroll_action_id = p_payroll_action_id
5068: AND pec.enc_control_id = pesl.enc_control_id
5069: AND pesl.status_code = 'N'

Line 7329: FROM per_all_people_f

7325:
7326: CURSOR get_full_name_cur (p_person_id IN NUMBER,
7327: p_effective_date IN DATE) IS
7328: SELECT full_name
7329: FROM per_all_people_f
7330: WHERE person_id = p_person_id
7331: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
7332: begin
7333: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering LIQUIDATE_EMP_TERM');