APPS.PER_NL_DSR_ARCHIVE dependencies on PER_JOBS

Line 1492: ,per_jobs pj

1488: CURSOR csr_get_job(p_assignment_id IN NUMBER
1489: , p_start_date IN DATE ) IS
1490: SELECT pj.name
1491: FROM per_all_assignments_f pas
1492: ,per_jobs pj
1493: WHERE pas.assignment_id = p_assignment_id
1494: AND p_start_date BETWEEN pas.effective_start_date
1495: AND pas.effective_end_date
1496: AND pas.job_id = pj.job_id

Line 1763: l_job_name per_jobs.name%TYPE;

1759: l_assignment_id NUMBER :=NULL;
1760: l_sick_ph_no per_phones.phone_number%TYPE;
1761: l_for_sick_ph_no per_phones.phone_number%TYPE;
1762: l_sick_mobile_no per_phones.phone_number%TYPE;
1763: l_job_name per_jobs.name%TYPE;
1764: l_fz_code per_assignment_extra_info.aei_information3%TYPE;
1765: l_contract per_shared_types.system_type_cd%TYPE;
1766: l_action_info_id NUMBER;
1767: l_ovn NUMBER;