APPS.GHR_MTO_INT dependencies on GHR_MT_ASSIGNMENT_EI_V

Line 2268: insert into ghr_mt_assignment_ei_v (

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

Line 2457: from ghr_mt_assignment_ei_v

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

Line 2512: update ghr_mt_assignment_ei_v

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