APPS.PER_NEW_HIRE_PKG dependencies on PER_JOBS

Line 2495: v_contact_title varchar2(700); --per_jobs.name%TYPE;

2491: ) IS
2492: --
2493: l_api_name varchar2(61) := g_package_name || '.get_new_hire_contact';
2494: v_contact_name varchar2(240); --per_people_f.full_name%TYPE;
2495: v_contact_title varchar2(700); --per_jobs.name%TYPE;
2496: v_contact_phone varchar2(60); -- per_people_f.work_telephone%TYPE;
2497:
2498: CURSOR c_new_hire_record IS
2499: Select ppf.first_name || ' ' || ppf.last_name,

Line 2507: per_jobs job

2503: --per_people_f ppf, --view bug 4912696
2504: per_all_people_f ppf, --table
2505: --per_assignments_f paf, --view bug 4912696
2506: per_all_assignments_f paf, --table
2507: per_jobs job
2508: Where
2509: ppf.person_id = p_person_id
2510: And ppf.business_group_id + 0 = p_business_group_id
2511: And p_report_date between paf.effective_start_date