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 4097: l_contact_person_id per_people_f.person_id%type;

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

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

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

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

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