APPS.HR_US_REPORTS dependencies on PER_JOBS

Line 320: v_contact_title per_jobs.name%TYPE;

316: p_contact_phone out nocopy varchar2
317: ) IS
318: --
319: v_contact_name per_people_f.full_name%TYPE;
320: v_contact_title per_jobs.name%TYPE;
321: v_contact_phone per_people_f.work_telephone%TYPE;
322:
323: CURSOR c_new_hire_record IS
324: Select ppf.full_name,

Line 330: per_jobs job

326: ppf.work_telephone
327: From
328: per_people_f ppf,
329: per_assignments_f paf,
330: per_jobs job
331: Where
332: ppf.person_id = p_person_id
333: And ppf.business_group_id + 0 = p_business_group_id
334: And p_report_date between paf.effective_start_date