APPS.PAY_SE_STAT_OFFICE_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 434: FROM per_all_assignments_f paa,

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

Line 602: l_assignment_id PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;

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