APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_CUST_ACCOUNT_ROLES_M

Line 884: AND cm.duplicate_id <> cm.customer_id) cm, hz_cust_account_roles_m carf

880: Decode(carf.cust_acct_site_id, NULL,cm.customer_id,cm.customer_address_id) to_parent_id, 'Transfer' operation
881: FROM (SELECT DISTINCT duplicate_id, duplicate_address_id, customer_address_id, customer_id
882: FROM ra_customer_merges cm
883: WHERE cm.customer_merge_header_id = p_customer_merge_header_id
884: AND cm.duplicate_id <> cm.customer_id) cm, hz_cust_account_roles_m carf
885: WHERE carf.customer_merge_header_id = p_customer_merge_header_id
886: AND ((carf.cust_account_id = cm.duplicate_id AND carf.cust_acct_site_id = cm.duplicate_address_id)
887: OR (carf.cust_account_id = cm.duplicate_id AND carf.cust_acct_site_id IS NULL))
888: AND NOT EXISTS (SELECT 'Y'

Line 1307: FROM hz_cust_account_roles_m

1303:
1304: l_site_use_id := null;
1305:
1306: SELECT cust_acct_site_id INTO l_site_use_id
1307: FROM hz_cust_account_roles_m
1308: WHERE cust_account_role_id = x_account_merge_v2_obj.acct_role_objs(I).from_object_id;
1309:
1310: IF l_site_use_id IS NOT NULL THEN
1311: