APPS.GHR_MTO_INT dependencies on GHR_MT_ADDRESSES_V

Line 1588: insert into ghr_mt_addresses_v (

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

Line 1728: from ghr_mt_addresses_v

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

Line 1751: update ghr_mt_addresses_v

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