APPS.JTF_TASK_CUST_MERGE_PKG dependencies on RA_CUSTOMER_MERGES

Line 49: FROM ra_customer_merges m

45: BEGIN
46: g_acctnum_list.DELETE;
47:
48: FOR CUST IN (SELECT distinct m.customer_id, acct.account_number
49: FROM ra_customer_merges m
50: , hz_cust_accounts acct
51: WHERE m.set_number = p_set_num
52: AND m.request_id = p_request_id
53: AND m.process_flag = 'N'

Line 107: FROM JTF_TASKS_B yt, ra_customer_merges m

103: CURSOR merged_records IS
104: SELECT distinct CUSTOMER_MERGE_HEADER_ID
105: ,task_id
106: ,cust_account_id
107: FROM JTF_TASKS_B yt, ra_customer_merges m
108: WHERE (
109: yt.cust_account_id = m.DUPLICATE_ID
110: ) AND m.process_flag = 'N'
111: AND m.request_id = p_request_id

Line 239: FROM JTF_TASK_AUDITS_B yt, ra_customer_merges m

235: SELECT distinct CUSTOMER_MERGE_HEADER_ID
236: ,task_audit_id
237: ,old_cust_account_id
238: ,new_cust_account_id
239: FROM JTF_TASK_AUDITS_B yt, ra_customer_merges m
240: WHERE (
241: yt.old_cust_account_id = m.DUPLICATE_ID
242: OR yt.new_cust_account_id = m.DUPLICATE_ID
243: ) AND m.process_flag = 'N'

Line 378: , ra_customer_merges m

374: ,cn.QUERY_PARAM_ID
375: ,cn.PARAMETER_VALUE
376: FROM JTF_PERZ_QUERY_PARAM yt
377: , JTF_PERZ_QUERY_PARAM cn
378: , ra_customer_merges m
379: WHERE yt.PARAMETER_VALUE = to_char(m.DUPLICATE_ID)
380: AND m.process_flag = 'N'
381: AND m.request_id = p_request_id
382: AND m.set_number = p_set_number