APPS.GHR_MTO_INT dependencies on GHR_MT_POSITION_EI_V

Line 2963: insert into ghr_mt_position_ei_v (

2959:
2960: end if;
2961:
2962:
2963: insert into ghr_mt_position_ei_v (
2964: GHR_INTERFACE_ID,
2965: MT_PROCESS_DATE,
2966: MT_SOURCE,
2967: MT_EFFECTIVE_DATE,

Line 3161: from ghr_mt_position_ei_v

3157: l_info16_meaning varchar2(80) := null;
3158:
3159: cursor cur_position_ei is
3160: select 'x'
3161: from ghr_mt_position_ei_v
3162: where mt_name = p_transfer_name
3163: and mt_person_id = to_char(p_person_id)
3164: and mt_information_type = p_pos_ei.information_type
3165: for update;

Line 3223: update ghr_mt_position_ei_v

3219:
3220:
3221: end if;
3222:
3223: update ghr_mt_position_ei_v
3224: set
3225: MT_EFFECTIVE_DATE = p_effective_date,
3226: POSITION_EXTRA_INFO_ID =
3227: nvl(p_pos_ei.POSITION_EXTRA_INFO_ID,POSITION_EXTRA_INFO_ID),