APPS.PER_AE_XDO_REPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 53: FROM per_all_assignments_f assg

49: ,dei.dei_information1 visa_number
50: ,dei.dei_information9 place_of_issue
51: ,dei.date_to expiry_date
52: ,assg.assignment_id assignment_id
53: FROM per_all_assignments_f assg
54: ,per_all_people_f people
55: ,hr_document_extra_info dei
56: ,hr_document_types_tl hdtl
57: ,hr_all_organization_units org

Line 81: FROM per_all_assignments_f paa,

77: 'Y',(add_months(NVL(l_date,sysdate),(p_expires_in*12))))
78: ORDER BY org.name, expiry_date, full_name;
79: CURSOR csr_get_job(p_assignment_id NUMBER) IS
80: SELECT pjb.name
81: FROM per_all_assignments_f paa,
82: per_jobs pjb
83: WHERE paa.assignment_id = p_assignment_id
84: AND paa.job_id = pjb.job_id;
85: rec_get_visa_det csr_get_visa_det%ROWTYPE;

Line 431: FROM per_all_assignments_f assg

427: ,dei.dei_information1 passport_number
428: ,dei.issued_at place_of_issue
429: ,dei.date_to expiry_date
430: ,assg.assignment_id assignment_id
431: FROM per_all_assignments_f assg
432: ,per_all_people_f people
433: ,hr_document_extra_info dei
434: ,hr_document_types_tl hdtl
435: ,hr_all_organization_units org

Line 459: FROM per_all_assignments_f paa,

455: 'Y',(add_months(NVL(l_date,sysdate),(p_expires_in*12))))
456: ORDER BY org.name, expiry_date, full_name;
457: CURSOR csr_get_job(p_assignment_id NUMBER) IS
458: SELECT pjb.name
459: FROM per_all_assignments_f paa,
460: per_jobs pjb
461: WHERE paa.assignment_id = p_assignment_id
462: AND paa.job_id = pjb.job_id;
463: rec_get_pass_det csr_get_pass_det%ROWTYPE;

Line 857: FROM per_all_assignments_f assg

853: ,cont.reference cont_reference
854: ,get_lookup_meaning('CONTRACT_TYPE',cont.type) cont_type
855: ,cont.ctr_information1 employment_status
856: ,fnd_date.canonical_to_date(cont.ctr_information2) expiry_date
857: FROM per_all_assignments_f assg
858: ,per_all_people_f people
859: ,per_contracts cont
860: ,per_jobs job
861: ,per_periods_of_service period