APPS.PAY_AE_ARCHIVE dependencies on PER_JOBS

Line 976: FROM per_jobs

972:
973: /* Cursor to pick up Job */
974: CURSOR csr_job(p_job_id NUMBER) IS
975: SELECT name
976: FROM per_jobs
977: WHERE job_id = p_job_id;
978:
979: /* Cursor to retrieve Cost Center */
980: CURSOR csr_cost_center(p_assignment_id NUMBER) IS

Line 994: l_job per_jobs.name%TYPE;

990: rec_org_address csr_organization_address%ROWTYPE;
991: l_nationality VARCHAR2(80); --per_all_people_f.nationality%TYPE;
992: l_position per_all_positions.name%TYPE;
993: l_grade per_grades.name%TYPE;
994: l_job per_jobs.name%TYPE;
995: l_currency hr_organization_information.org_information10%TYPE;
996: l_organization hr_organization_units.name%TYPE;
997: l_pay_location hr_locations_all.address_line_1%TYPE;
998: l_city VARCHAR2(80);