APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PER_JOBS

Line 1388: FROM per_jobs

1384: WHERE pap.position_id = p_position_id;
1385: -------------
1386: CURSOR csr_job (p_job_id NUMBER)IS
1387: SELECT name
1388: FROM per_jobs
1389: WHERE job_id = p_job_id;
1390: -------------
1391: /* Cursor to retrieve Cost Center */
1392: CURSOR csr_cost_center(p_assignment_id NUMBER) IS

Line 1476: l_job PER_JOBS.NAME%TYPE;

1472: l_person_id NUMBER;
1473: l_employer_name hr_organization_units.name%TYPE;
1474: l_local_unit_id hr_organization_units.organization_id%TYPE;
1475: l_legal_employer_id hr_organization_units.organization_id%TYPE;
1476: l_job PER_JOBS.NAME%TYPE;
1477: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
1478: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
1479: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;
1480: l_defined_balance_id NUMBER;