DBA Data[Home] [Help]

APPS.GHR_MTO_INT dependencies on GHR_MT_POSITION_EI_V

Line 2964: insert into ghr_mt_position_ei_v (

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

Line 3162: from ghr_mt_position_ei_v

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

Line 3224: update ghr_mt_position_ei_v

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