APPS.PAY_AU_PAYE_FF dependencies on PER_ALL_PEOPLE_F

Line 4536: l_emp_num per_all_people_f.employee_number%TYPE;

4532: l_entry_information pay_element_entries_f.entry_information1%type;
4533: l_count NUMBER := 0;
4534: l_asg_exist NUMBER := 0;
4535: l_upgraded NUMBER := 0;
4536: l_emp_num per_all_people_f.employee_number%TYPE;
4537: l_ovn NUMBER := -1;
4538: l_start DATE;
4539: l_asg_mode varchar2(60);
4540: l_soft_code_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE := -1;

Line 4734: from per_all_people_f pap

4730:
4731: CURSOR get_emp_details(p_assignment_id IN NUMBER)
4732: IS
4733: SELECT pap.FULL_NAME,pap.EMPLOYEE_NUMBER
4734: from per_all_people_f pap
4735: where pap.person_id in
4736: ( select distinct person_id
4737: from per_all_assignments_f
4738: where assignment_id = p_assignment_id

Line 4741: from per_all_people_f papf

4737: from per_all_assignments_f
4738: where assignment_id = p_assignment_id
4739: )
4740: and pap.effective_end_date = ( select max(papf.effective_end_date)
4741: from per_all_people_f papf
4742: where papf.person_id in
4743: ( select distinct person_id
4744: from per_all_assignments_f
4745: where assignment_id = p_assignment_id