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 4018: p_person_id in per_all_people_f.person_id%type)

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

Line 4046: l_people_row per_all_people_f%rowtype;

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

Line 4099: from per_contact_relationships cr, per_all_people_f p

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