APPS.GHR_MTO_INT dependencies on GHR_MT_ADDRESSES_V

Line 1587: insert into ghr_mt_addresses_v (

1583: else
1584: put_line(' - called locally');
1585: end if;
1586:
1587: insert into ghr_mt_addresses_v (
1588: GHR_INTERFACE_ID,
1589: MT_PROCESS_DATE,
1590: MT_SOURCE,
1591: MT_EFFECTIVE_DATE,

Line 1727: from ghr_mt_addresses_v

1723: l_x varchar2(1);
1724:
1725: cursor cur_address is
1726: select 'x'
1727: from ghr_mt_addresses_v
1728: where mt_name = p_transfer_name
1729: and mt_person_id = to_char(p_a.person_id)
1730: and nvl(mt_contact_name,'null') = nvl(p_contact_name,'null')
1731: for update;

Line 1750: update ghr_mt_addresses_v

1746: hr_utility.set_message(8301, 'GHR_38549_UPDATE_NOT_FOUND');
1747: hr_utility.raise_error;
1748: end if;
1749:
1750: update ghr_mt_addresses_v
1751: set
1752: MT_EFFECTIVE_DATE = p_effective_date,
1753: ADDRESS_ID = nvl(p_a.ADDRESS_ID,ADDRESS_ID),
1754: BUSINESS_GROUP_ID = nvl(p_a.BUSINESS_GROUP_ID,BUSINESS_GROUP_ID),