APPS.GHR_MTO_INT dependencies on GHR_MT_ASSIGNMENT_EI_V

Line 2269: insert into ghr_mt_assignment_ei_v (

2265:
2266: end if;
2267:
2268:
2269: insert into ghr_mt_assignment_ei_v (
2270: GHR_INTERFACE_ID,
2271: MT_PROCESS_DATE,
2272: MT_SOURCE,
2273: MT_EFFECTIVE_DATE,

Line 2458: from ghr_mt_assignment_ei_v

2454: l_info8_meaning varchar2(80) := null;
2455:
2456: cursor cur_assignment_ei is
2457: select 'x'
2458: from ghr_mt_assignment_ei_v
2459: where mt_name = p_transfer_name
2460: and mt_person_id = to_char(p_person_id)
2461: and mt_information_type = p_a_ei.information_type
2462: for update;

Line 2513: update ghr_mt_assignment_ei_v

2509: p_lookup_code => p_a_ei.aei_information8);
2510:
2511: end if;
2512:
2513: update ghr_mt_assignment_ei_v
2514: set
2515: MT_EFFECTIVE_DATE = p_effective_date,
2516: ASSIGNMENT_EXTRA_INFO_ID =
2517: nvl(p_a_ei.ASSIGNMENT_EXTRA_INFO_ID,ASSIGNMENT_EXTRA_INFO_ID),