APPS.GHR_MTO_INT dependencies on GHR_MT_POSITION_DEFINITIONS_V

Line 3355: insert into ghr_mt_position_definitions_v (

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

Line 3481: from ghr_mt_position_definitions_v

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

Line 3509: update ghr_mt_position_definitions_v

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