APPS.GHR_MTO_INT dependencies on GHR_MT_POSITIONS_V

Line 2644: insert into ghr_mt_positions_v (

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

Line 2789: from ghr_mt_positions_v

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

Line 2807: update ghr_mt_positions_v

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