[Home] [Help]
APPS.HZ_ORG_CONTACT_BO_PUB dependencies on HZ_ORIG_SYS_REFERENCES
Line 326: FROM HZ_PARTIES per, HZ_ORIG_SYS_REFERENCES ref
322: l_eft_objs HZ_EFT_CP_BO_TBL;
323:
324: CURSOR get_per_id(l_os VARCHAR2, l_osr VARCHAR2) IS
325: SELECT per.party_id
326: FROM HZ_PARTIES per, HZ_ORIG_SYS_REFERENCES ref
327: WHERE ref.owner_table_id = per.party_id
328: AND ref.owner_table_name = 'HZ_PARTIES'
329: AND ref.orig_system = l_os
330: AND ref.orig_system_reference = l_osr