APPS.PAY_SE_STAT_OFFICE_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 433: FROM per_all_assignments_f paa,

429: pap.full_name,
430: '19' || substr(pap.national_identifier,0,6) || substr(pap.national_identifier,8) national_identifier,
431: paa.assignment_number employee_number,
432: paa.assignment_id
433: FROM per_all_assignments_f paa,
434: per_all_people_f pap,
435: HR_SOFT_CODING_KEYFLEX hsc,
436: per_person_types ppt
437: WHERE pap.person_id BETWEEN p_start_person AND p_end_person

Line 601: l_assignment_id PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;

597: l_all_local_unit_details_rec csr_all_local_unit_details%ROWTYPE;
598: l_assignments_rec csr_assignments%ROWTYPE;
599: l_total_sickness_days_rec csr_total_sickness_days%ROWTYPE;
600: ----
601: l_assignment_id PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
602: l_assact_id NUMBER;
603: l_ovn NUMBER;
604: l_action_info_id NUMBER;
605: l_exit_flag VARCHAR2(10);