APPS.PER_NEW_HIRE_PKG dependencies on PER_JOBS

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

5089: ) IS
5090: --
5091: l_api_name varchar2(61) := g_package_name || '.get_new_hire_contact';
5092: v_contact_name varchar2(240); --per_people_f.full_name%TYPE;
5093: v_contact_title varchar2(700); --per_jobs.name%TYPE;
5094: v_contact_phone varchar2(60); -- per_people_f.work_telephone%TYPE;
5095:
5096: CURSOR c_new_hire_record IS
5097: Select ppf.first_name || ' ' || ppf.last_name,

Line 5105: per_jobs job

5101: --per_people_f ppf, --view bug 4912696
5102: per_all_people_f ppf, --table
5103: --per_assignments_f paf, --view bug 4912696
5104: per_all_assignments_f paf, --table
5105: per_jobs job
5106: Where
5107: ppf.person_id = p_person_id
5108: And ppf.business_group_id + 0 = p_business_group_id
5109: And p_report_date between paf.effective_start_date