eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_ENC_SUM_TRAN dependencies on PER_ALL_PEOPLE_F

Line 4581: FROM per_all_people_f papf,

4577:
4578: CURSOR employee_number_cur IS
4579: SELECT DISTINCT pesl.person_id,
4580: papf.employee_number
4581: FROM per_all_people_f papf,
4582: psp_enc_summary_lines pesl
4583: WHERE pesl.payroll_action_id = p_payroll_action_id
4584: AND papf.person_id = pesl.person_id
4585: AND pesl.superceded_line_id IS NULL

Line 6851: l_full_name per_all_people_f.full_name%TYPE;

6847: l_person_id NUMBER(15);
6848: l_organization_id NUMBER(15);
6849: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
6850: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
6851: l_full_name per_all_people_f.full_name%TYPE;
6852: l_organization_name hr_organization_units.name%TYPE;
6853: l_element_name pay_element_types_f.element_name%TYPE;
6854: l_project_number pa_projects_all.segment1%TYPE;
6855: l_task_number pa_tasks.task_number%TYPE;

Line 6882: FROM per_all_people_f

6878: AND gl_set_of_books_id = g_set_of_books_id;
6879:
6880: CURSOR person_name_cur (p_effective_date IN DATE) IS
6881: SELECT full_name
6882: FROM per_all_people_f
6883: WHERE person_id = l_person_id
6884: AND effective_end_date >= p_effective_date
6885: AND ROWNUM = 1;
6886: