APPS.CSC_ACCOUNT_MERGE_PKG dependencies on HZ_CUST_ACCOUNTS

Line 80: FROM CSC_CUSTOMERS yt, ra_customer_merges m, hz_cust_accounts hzca

76: l_profile_val VARCHAR2(30);
77: CURSOR merged_records IS
78: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
79: ,m.customer_id, m.duplicate_id, hzca.party_id, yt.party_id
80: FROM CSC_CUSTOMERS yt, ra_customer_merges m, hz_cust_accounts hzca
81: WHERE ( yt.cust_account_id = m.duplicate_id AND m.customer_id = hzca.cust_account_id )
82: AND m.process_flag = 'N'
83: AND m.request_id = req_id
84: AND m.set_number = set_num;

Line 199: FROM CSC_CUSTOMERS_AUDIT_HIST yt, ra_customer_merges m , hz_cust_accounts hzca

195: l_profile_val VARCHAR2(30);
196: CURSOR merged_records IS
197: SELECT distinct CUSTOMER_MERGE_HEADER_ID
198: ,m.customer_id, m.duplicate_id
199: FROM CSC_CUSTOMERS_AUDIT_HIST yt, ra_customer_merges m , hz_cust_accounts hzca
200: WHERE ( yt.cust_account_id = m.duplicate_id AND m.customer_id = hzca.cust_account_id )
201: AND m.process_flag = 'N'
202: AND m.request_id = req_id
203: AND m.set_number = set_num;

Line 317: FROM CSC_CUSTOMIZED_PLANS yt, ra_customer_merges m , hz_cust_accounts hzca

313: l_profile_val VARCHAR2(30);
314: CURSOR merged_records IS
315: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
316: ,m.customer_id, m.duplicate_id, hzca.party_id, yt.party_id
317: FROM CSC_CUSTOMIZED_PLANS yt, ra_customer_merges m , hz_cust_accounts hzca
318: WHERE ( yt.cust_account_id = m.duplicate_id AND m.customer_id = hzca.cust_account_id )
319: AND m.process_flag = 'N'
320: AND m.request_id = req_id
321: AND m.set_number = set_num;

Line 448: FROM CSC_CUST_PLANS yt, ra_customer_merges m , hz_cust_accounts hzca

444: CURSOR merged_records IS
445: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
446: ,yt.cust_plan_id
447: ,m.customer_id, m.duplicate_id, hzca.party_id, yt.party_id
448: FROM CSC_CUST_PLANS yt, ra_customer_merges m , hz_cust_accounts hzca
449: WHERE ( yt.cust_account_id = m.duplicate_id AND m.customer_id = hzca.cust_account_id )
450: AND m.process_flag = 'N'
451: AND m.request_id = req_id
452: AND m.set_number = set_num;

Line 604: FROM CSC_CUST_PLANS_AUDIT yt, ra_customer_merges m , hz_cust_accounts hzca

600: CURSOR merged_records IS
601: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
602: ,yt.plan_audit_id
603: ,m.customer_id, m.duplicate_id, hzca.party_id, yt.party_id
604: FROM CSC_CUST_PLANS_AUDIT yt, ra_customer_merges m , hz_cust_accounts hzca
605: WHERE ( yt.cust_account_id = m.duplicate_id AND m.customer_id = hzca.cust_account_id )
606: AND m.process_flag = 'N'
607: AND m.request_id = req_id
608: AND m.set_number = set_num;