APPS.HR_US_REPORTS dependencies on PER_JOBS

Line 312: v_contact_title per_jobs.name%TYPE;

308: p_contact_phone out nocopy varchar2
309: ) IS
310: --
311: v_contact_name per_people_f.full_name%TYPE;
312: v_contact_title per_jobs.name%TYPE;
313: v_contact_phone per_people_f.work_telephone%TYPE;
314:
315: CURSOR c_new_hire_record IS
316: Select ppf.full_name,

Line 322: per_jobs job

318: ppf.work_telephone
319: From
320: per_people_f ppf,
321: per_assignments_f paf,
322: per_jobs job
323: Where
324: ppf.person_id = p_person_id
325: And ppf.business_group_id + 0 = p_business_group_id
326: And p_report_date between paf.effective_start_date