APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_ACCT_ORIG_SYS_REF_OBJ

Line 97: HZ_ACCT_ORIG_SYS_REF_OBJ(

93: fp.party_number,
94: fp.party_name,
95: fp.party_type,
96: HZ_ORIG_SYS_REF_OBJ_TBL()),
97: HZ_ACCT_ORIG_SYS_REF_OBJ(
98: ta.cust_account_id,
99: ta.account_name,
100: ta.account_number,
101: HZ_ORIG_SYS_REF_OBJ_TBL()),

Line 103: SELECT HZ_ACCT_ORIG_SYS_REF_OBJ(

99: ta.account_name,
100: ta.account_number,
101: HZ_ORIG_SYS_REF_OBJ_TBL()),
102: CAST(MULTISET (
103: SELECT HZ_ACCT_ORIG_SYS_REF_OBJ(
104: fa.cust_account_id,
105: fa.account_name,
106: fa.account_number,
107: HZ_ORIG_SYS_REF_OBJ_TBL())

Line 110: ) AS HZ_ACCT_ORIG_SYS_REF_OBJ_TBL)

106: fa.account_number,
107: HZ_ORIG_SYS_REF_OBJ_TBL())
108: FROM hz_cust_accounts fa
109: WHERE fa.cust_account_id = mh.duplicate_id
110: ) AS HZ_ACCT_ORIG_SYS_REF_OBJ_TBL)
111: )
112: FROM ra_customer_merge_headers mh, hz_cust_accounts ta, hz_parties tp, hz_cust_accounts fa, hz_parties fp
113: WHERE mh.customer_merge_header_id = p_customer_merge_header_id
114: AND ta.cust_account_id = mh.customer_id