APPS.PSP_ENC_SUM_TRAN dependencies on PER_ALL_PEOPLE_F

Line 4626: ,per_all_people_f papf --Added for Bug 10126350

4622: pa_projects_all ppa,
4623: pa_tasks_expend_v pt, -- Bug : 16391366 (20/03/2013)
4624: per_time_periods ptp,
4625: psp_enc_controls pec
4626: ,per_all_people_f papf --Added for Bug 10126350
4627: WHERE pec.payroll_action_id = p_payroll_action_id
4628: AND pec.enc_control_id = pesl.enc_control_id
4629: AND pesl.status_code = 'N'
4630: AND pesl.gl_code_combination_id IS NULL

Line 4690: FROM per_all_people_f papf,

4686:
4687: CURSOR employee_number_cur IS
4688: SELECT DISTINCT pesl.person_id,
4689: papf.employee_number
4690: FROM per_all_people_f papf,
4691: psp_enc_summary_lines pesl
4692: WHERE pesl.payroll_action_id = p_payroll_action_id
4693: AND papf.person_id = pesl.person_id
4694: AND pesl.superceded_line_id IS NULL

Line 7087: l_full_name per_all_people_f.full_name%TYPE;

7083: l_person_id NUMBER(15);
7084: l_organization_id NUMBER(15);
7085: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
7086: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
7087: l_full_name per_all_people_f.full_name%TYPE;
7088: l_organization_name hr_organization_units.name%TYPE;
7089: l_element_name pay_element_types_f.element_name%TYPE;
7090: l_project_number pa_projects_all.segment1%TYPE;
7091: l_task_number VARCHAR2(300); -- pa_tasks.task_number%TYPE; -- Bug 16391366 (27/03/2013)

Line 7118: FROM per_all_people_f

7114: AND gl_set_of_books_id = g_set_of_books_id;
7115:
7116: CURSOR person_name_cur (p_effective_date IN DATE) IS
7117: SELECT full_name
7118: FROM per_all_people_f
7119: WHERE person_id = l_person_id
7120: AND effective_end_date >= p_effective_date
7121: AND ROWNUM = 1;
7122: