APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_CUST_PROFILE_AMTS

Line 820: get_object_type('HZ_CUST_PROFILE_AMTS', from_profile_amt_id),

816:
817: CURSOR get_cust_profile_amts IS
818:
819: SELECT HZ_ACCOUNT_MERGE_DETAIL_OBJ(
820: get_object_type('HZ_CUST_PROFILE_AMTS', from_profile_amt_id),
821: operation,
822: NULL,
823: NULL,
824: from_profile_amt_id,

Line 836: FROM ra_customer_merge_headers cmh, hz_cust_profile_amts_m cpaf, hz_cust_profile_amts cpat

832: )
833: FROM (SELECT 'Merge' operation, cpaf.cust_acct_profile_amt_id from_profile_amt_id,
834: cpat.cust_acct_profile_amt_id to_profile_amt_id,
835: cmh.duplicate_id from_parent_id, cmh.customer_id to_parent_id
836: FROM ra_customer_merge_headers cmh, hz_cust_profile_amts_m cpaf, hz_cust_profile_amts cpat
837: WHERE cmh.customer_merge_header_id = p_customer_merge_header_id
838: AND cmh.duplicate_id <> cmh.customer_id
839: AND cpaf.customer_merge_header_id = p_customer_merge_header_id
840: AND cpaf.cust_account_id = cmh.duplicate_id

Line 853: FROM ra_customer_merges cm, hz_cust_profile_amts_m cpaf, hz_cust_profile_amts cpat

849: cpaf.cust_acct_profile_amt_id from_profile_amt_id,
850: cpat.cust_acct_profile_amt_id to_profile_amt_id,
851: cm.duplicate_site_id from_parent_id,
852: cm.customer_site_id to_parent_id
853: FROM ra_customer_merges cm, hz_cust_profile_amts_m cpaf, hz_cust_profile_amts cpat
854: WHERE cm.customer_merge_header_id = p_customer_merge_header_id
855: AND cpaf.customer_merge_header_id = p_customer_merge_header_id
856: AND cpaf.cust_account_id = cm.duplicate_id
857: AND cpaf.site_use_id = cm.duplicate_site_id

Line 1205: FROM hz_cust_profile_amts_m

1201:
1202: FOR I IN 1..x_account_merge_v2_obj.cust_profile_amt_objs.count LOOP
1203: l_site_use_id := null;
1204: SELECT site_use_id INTO l_site_use_id
1205: FROM hz_cust_profile_amts_m
1206: WHERE cust_acct_profile_amt_id = x_account_merge_v2_obj.cust_profile_amt_objs(I).from_object_id;
1207:
1208: IF l_site_use_id IS NOT NULL THEN
1209: