APPS.GHR_MTO_INT dependencies on GHR_MT_POSITIONS_V

Line 2645: insert into ghr_mt_positions_v (

2641: else
2642: put_line(' - called locally');
2643: end if;
2644:
2645: insert into ghr_mt_positions_v (
2646: GHR_INTERFACE_ID,
2647: MT_PROCESS_DATE,
2648: MT_SOURCE,
2649: MT_EFFECTIVE_DATE,

Line 2790: from ghr_mt_positions_v

2786: l_x varchar2(1);
2787:
2788: cursor cur_position is
2789: select 'x'
2790: from ghr_mt_positions_v
2791: where mt_name = p_transfer_name
2792: and mt_person_id = to_char(p_person_id)
2793: for update;
2794:

Line 2808: update ghr_mt_positions_v

2804: hr_utility.set_message(8301, 'GHR_38549_UPDATE_NOT_FOUND');
2805: hr_utility.raise_error;
2806: end if;
2807:
2808: update ghr_mt_positions_v
2809: set
2810: MT_EFFECTIVE_DATE = p_effective_date,
2811: POSITION_ID = nvl(p_pos.POSITION_ID,POSITION_ID),
2812: BUSINESS_GROUP_ID = nvl(p_pos.BUSINESS_GROUP_ID,BUSINESS_GROUP_ID),