APPS.GHR_MTO_INT dependencies on GHR_MT_PEOPLE_F_V

Line 374: insert into ghr_mt_people_f_v (

370: else
371: put_line(' - called locally');
372: end if;
373:
374: insert into ghr_mt_people_f_v (
375: ghr_interface_id,
376: MT_PROCESS_DATE, MT_SOURCE, MT_EFFECTIVE_DATE,
377: MT_NAME, MT_STATUS, MT_PERSON_ID,
378: MT_TABLE_NAME, MT_INFORMATION_TYPE,

Line 582: from ghr_mt_people_f_v

578: l_x varchar2(1);
579:
580: cursor cur_get_person is
581: select 'x'
582: from ghr_mt_people_f_v
583: where mt_name = p_transfer_name
584: and mt_person_id = to_char(ppf.person_id)
585: for update;
586:

Line 600: update ghr_mt_people_f_v

596: hr_utility.set_message(8301, 'GHR_38549_UPDATE_NOT_FOUND');
597: hr_utility.raise_error;
598: end if;
599:
600: update ghr_mt_people_f_v
601: set
602: MT_EFFECTIVE_DATE = p_effective_date,
603: MT_INTER_BG_TRANSFER = p_inter_bg_transfer,
604: BUSINESS_GROUP_ID = nvl(ppf.BUSINESS_GROUP_ID,BUSINESS_GROUP_ID),