APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_CUST_ACCOUNT_ROLES

Line 864: get_object_type('HZ_CUST_ACCOUNT_ROLES',from_role_id),

860: AND cpaf.currency_code = cpat.currency_code);
861:
862: CURSOR get_account_roles IS
863: SELECT HZ_ACCOUNT_MERGE_DETAIL_OBJ(
864: get_object_type('HZ_CUST_ACCOUNT_ROLES',from_role_id),
865: operation,
866: NULL,
867: NULL,
868: from_role_id,

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 889: FROM hz_cust_account_roles

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'
889: FROM hz_cust_account_roles
890: WHERE cust_account_role_id = carf.cust_account_role_id
891: AND cust_account_id = cm.duplicate_id));
892:
893: CURSOR get_acct_rels(duplicate_id number, customer_id number) IS

Line 1279: p_owner_table_name => 'HZ_CUST_ACCOUNT_ROLES',

1275:
1276: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1277: (p_init_msg_list => fnd_api.g_false,
1278: p_owner_table_id => x_account_merge_v2_obj.acct_role_objs(I).from_object_id,
1279: p_owner_table_name => 'HZ_CUST_ACCOUNT_ROLES',
1280: p_action_type => NULL,
1281: x_orig_sys_ref_objs => x_account_merge_v2_obj.acct_role_objs(I).from_object_sys_ref_objs,
1282: x_return_status => x_return_status,
1283: x_msg_count => x_msg_count,

Line 1293: p_owner_table_name => 'HZ_CUST_ACCOUNT_ROLES',

1289:
1290: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1291: (p_init_msg_list => fnd_api.g_false,
1292: p_owner_table_id => x_account_merge_v2_obj.acct_role_objs(I).to_object_id,
1293: p_owner_table_name => 'HZ_CUST_ACCOUNT_ROLES',
1294: p_action_type => NULL,
1295: x_orig_sys_ref_objs => x_account_merge_v2_obj.acct_role_objs(I).to_object_sys_ref_objs,
1296: x_return_status => x_return_status,
1297: x_msg_count => x_msg_count,

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: