APPS.GHR_MTO_INT dependencies on GHR_MT_PEOPLE_EI_V

Line 908: insert into ghr_mt_people_ei_v (

904: p_lookup_code => pp_ei.pei_information5);
905:
906: end if;
907:
908: insert into ghr_mt_people_ei_v (
909: GHR_INTERFACE_ID,
910: MT_PROCESS_DATE,
911: MT_SOURCE,
912: MT_EFFECTIVE_DATE,

Line 1107: from ghr_mt_people_ei_v

1103: l_x varchar2(1);
1104:
1105: cursor cur_get_person_ei is
1106: select 'x' -- mt_person_id
1107: from ghr_mt_people_ei_v
1108: where mt_name = p_transfer_name
1109: and mt_person_id = to_char(pp_ei.person_id)
1110: and mt_information_type = pp_ei.information_type
1111: for update;

Line 1198: update ghr_mt_people_ei_v

1194: p_lookup_code => pp_ei.pei_information5);
1195:
1196: end if;
1197:
1198: update ghr_mt_people_ei_v
1199: set
1200: MT_EFFECTIVE_DATE = nvl(p_EFFECTIVE_DATE,MT_EFFECTIVE_DATE),
1201: PERSON_EXTRA_INFO_ID =
1202: nvl(pp_ei.PERSON_EXTRA_INFO_ID,PERSON_EXTRA_INFO_ID),