APPS.PAY_KW_ARCHIVE dependencies on PER_JOBS

Line 973: FROM per_jobs

969:
970: /* Cursor to pick up Job */
971: CURSOR csr_job(p_job_id NUMBER) IS
972: SELECT name
973: FROM per_jobs
974: WHERE job_id = p_job_id;
975:
976: rec_person_details csr_person_details%ROWTYPE;
977: rec_primary_address csr_primary_address%ROWTYPE;

Line 983: l_job per_jobs.name%TYPE;

979: rec_org_address csr_organization_address%ROWTYPE;
980: l_nationality per_all_people_f.nationality%TYPE;
981: l_position per_all_positions.name%TYPE;
982: l_grade per_grades.name%TYPE;
983: l_job per_jobs.name%TYPE;
984: l_currency hr_organization_information.org_information10%TYPE;
985: l_organization hr_organization_units.name%TYPE;
986: l_pay_location hr_locations_all.address_line_1%TYPE;
987: l_city VARCHAR2(80);