APPS.GHR_MTO_INT dependencies on PER_ALL_PEOPLE_F

Line 341: ppf per_all_people_f%rowtype)

337: --
338: procedure insert_people_f(p_transfer_name varchar2,
339: p_inter_bg_transfer varchar2,
340: p_effective_date date,
341: ppf per_all_people_f%rowtype)
342: is
343:
344: l_proc varchar2(72) := g_package||'insert_people_f';
345: l_table_name constant varchar2(30) := 'PER_PEOPLE_F';

Line 572: ppf per_all_people_f%rowtype)

568:
569: procedure update_people_f(p_transfer_name varchar2,
570: p_inter_bg_transfer varchar2,
571: p_effective_date date,
572: ppf per_all_people_f%rowtype)
573: is
574:
575: l_proc varchar2(72) := g_package||'update_people_f';
576: l_table_name constant varchar2(30) := 'PER_PEOPLE_F';

Line 4019: p_person_id in per_all_people_f.person_id%type)

4015: --
4016: procedure mass_transfer_out(p_errbuf out nocopy varchar2,
4017: p_retcode out nocopy number,
4018: p_transfer_id in number,
4019: p_person_id in per_all_people_f.person_id%type)
4020: is
4021: l_proc_name varchar2(30) := 'mass_transfer_out';
4022: l_proc varchar2(72) := g_package||l_proc_name;
4023:

Line 4047: l_people_row per_all_people_f%rowtype;

4043: l_rc varchar2(30);
4044: l_inter_bg_transfer varchar2(1);
4045:
4046: ---------------
4047: l_people_row per_all_people_f%rowtype;
4048: l_position_row hr_all_positions_f%rowtype;
4049: l_people_ei_row per_people_extra_info%rowtype;
4050: l_element ghr_mt_element_entries_v%rowtype;
4051: l_misc ghr_mt_misc_v%rowtype;

Line 4100: from per_contact_relationships cr, per_all_people_f p

4096: l_contact_name varchar2(240);
4097: l_contact_person_id per_people_f.person_id%type;
4098: cursor cur_contact_info(p_person_id number) is
4099: select cr.contact_type, p.full_name, cr.contact_person_id
4100: from per_contact_relationships cr, per_all_people_f p
4101: where cr.person_id = p_person_id
4102: and cr.primary_contact_flag = 'Y'
4103: and cr.contact_person_id = p.person_id
4104: and trunc(l_effdate) between p.effective_start_date