APPS.GHR_MTO_INT dependencies on PER_PEOPLE_F

Line 345: l_table_name constant varchar2(30) := 'PER_PEOPLE_F';

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';
346:
347: l_owner varchar2(30);
348: l_name varchar2(30);
349: l_lineno number;

Line 576: l_table_name constant varchar2(30) := 'PER_PEOPLE_F';

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';
577: l_name varchar2(30);
578: l_x varchar2(1);
579:
580: cursor cur_get_person is

Line 4096: l_contact_person_id per_people_f.person_id%type;

4092: l_position_ei_row per_position_extra_info%rowtype;
4093:
4094: l_contact_type varchar2(30);
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

Line 4160: 'Could not query data from PER_PEOPLE_F for person_id:'||

4156:
4157: log_message(
4158: p_procedure => l_proc_name,
4159: p_message =>
4160: 'Could not query data from PER_PEOPLE_F for person_id:'||
4161: p_person_id);
4162:
4163: commit;
4164: hr_utility.set_message(8301, 'GHR_38536_MTO_NO_PERSON');

Line 4174: ,p_table_name => 'PER_PEOPLE_F') then

4170: -- inserting new data
4171: if row_exists(
4172: p_transfer_name => l_transfer_name
4173: ,p_person_id => p_person_id
4174: ,p_table_name => 'PER_PEOPLE_F') then
4175:
4176: put_line('------------------------------------------');
4177: put_line('Person '||p_person_id||', found in table');
4178: put_line('------------------------------------------');