APPS.PER_AE_XDO_REPORT dependencies on PER_JOBS

Line 82: per_jobs pjb

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;
86: l_org_name VARCHAR2(80);

Line 460: per_jobs pjb

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;
464: l_org_name VARCHAR2(80);

Line 860: ,per_jobs job

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
862: ,hr_all_organization_units org
863: WHERE assg.person_id = people.person_id
864: AND (l_date) BETWEEN assg.effective_start_date