APPS.GHR_MTO_INT dependencies on GHR_MT_POSITION_DEFINITIONS_V

Line 3354: insert into ghr_mt_position_definitions_v (

3350: else
3351: put_line('Called locally');
3352: end if;
3353:
3354: insert into ghr_mt_position_definitions_v (
3355: GHR_INTERFACE_ID,
3356: MT_PROCESS_DATE,
3357: MT_SOURCE,
3358: MT_EFFECTIVE_DATE,

Line 3480: from ghr_mt_position_definitions_v

3476: l_x varchar2(1);
3477:
3478: cursor cur_pos_defs is
3479: select 'x'
3480: from ghr_mt_position_definitions_v
3481: where mt_name = p_transfer_name
3482: and mt_person_id = to_char(p_person_id)
3483: and mt_information_type = p_flex_name
3484: for update;

Line 3508: update ghr_mt_position_definitions_v

3504:
3505: return;
3506: end if;
3507:
3508: update ghr_mt_position_definitions_v
3509: set
3510: MT_EFFECTIVE_DATE = p_effective_date,
3511: POSITION_DEFINITION_ID =
3512: nvl(p_pos_defs.POSITION_DEFINITION_ID,POSITION_DEFINITION_ID),