APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_ACCOUNT_MERGE_DETAIL_OBJ

Line 383: SELECT HZ_ACCOUNT_MERGE_DETAIL_OBJ(

379: AND rownum = 1;
380:
381: CURSOR get_site_details IS
382:
383: SELECT HZ_ACCOUNT_MERGE_DETAIL_OBJ(
384: get_object_type('HZ_CUST_ACCT_SITES', cm.duplicate_address_id),
385: decode(cm.customer_createsame, 'N', 'Merge', 'Y', 'Transfer'),
386: cm.org_id,
387: get_operating_unit(cm.org_id),

Line 581: SELECT HZ_ACCOUNT_MERGE_DETAIL_OBJ(

577: AND duplicate_id <> customer_id) cm;
578:
579: CURSOR get_site_use_details IS
580:
581: SELECT HZ_ACCOUNT_MERGE_DETAIL_OBJ(
582: get_object_type('HZ_CUST_SITE_USES', cm.duplicate_site_id),
583: decode(cm.customer_createsame, 'N', 'Merge', 'Y', 'Transfer'),
584: cm.org_id,
585: get_operating_unit(cm.org_id),

Line 776: SELECT HZ_ACCOUNT_MERGE_DETAIL_OBJ(

772: WHERE customer_merge_header_id = p_customer_merge_header_id;
773:
774: CURSOR get_customer_profiles IS
775:
776: SELECT HZ_ACCOUNT_MERGE_DETAIL_OBJ(
777: get_object_type('HZ_CUSTOMER_PROFILES', from_profile_id),
778: operation,
779: NULL,
780: NULL,

Line 819: SELECT HZ_ACCOUNT_MERGE_DETAIL_OBJ(

815: AND cpt.site_use_id = cm.customer_site_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,

Line 863: SELECT HZ_ACCOUNT_MERGE_DETAIL_OBJ(

859: AND cpat.site_use_id = cm.customer_site_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,

Line 894: SELECT HZ_ACCOUNT_MERGE_DETAIL_OBJ(

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
894: SELECT HZ_ACCOUNT_MERGE_DETAIL_OBJ(
895: get_object_type('HZ_CUST_ACCT_RELATE_ALL',crelf.cust_acct_relate_id),
896: decode(crelt.created_by_module,'HZ_TCA_CUSTOMER_MERGE','Transfer','Merge'),
897: crelt.org_id,
898: get_operating_unit(crelt.org_id),