APPS.FII_AR_ACCOUNT_MERGE_PKG dependencies on RA_CUSTOMER_MERGES

Line 50: ra_customer_merges m

46: yt.BILL_TO_SITE_USE_ID,
47: m.CUSTOMER_ID,
48: m.customer_site_id
49: FROM FII_AR_PMT_SCHEDULES_F yt,
50: ra_customer_merges m
51: WHERE (yt.BILL_TO_CUSTOMER_ID = m.duplicate_id
52: AND yt.BILL_TO_SITE_USE_ID = m.duplicate_site_id)
53: AND m.process_flag = 'N'
54: AND m.request_id = req_id

Line 253: ra_customer_merges m

249: yt.site_use_id,
250: m.CUSTOMER_ID,
251: m.customer_site_id
252: FROM FII_COLLECTORS yt,
253: ra_customer_merges m
254: WHERE (yt.cust_account_id = m.duplicate_id
255: AND yt.site_use_id = m.duplicate_site_id)
256: AND (m.customer_id, m.customer_site_id) not in
257: (select cust_account_id, site_use_id

Line 270: ra_customer_merges m

266: yt.site_use_id,
267: yt.party_id,
268: yt.collector_id
269: FROM FII_COLLECTORS yt,
270: ra_customer_merges m
271: WHERE yt.cust_account_id = m.duplicate_id
272: AND m.customer_id in
273: (select cust_account_id
274: from fii_collectors)

Line 464: TABLE OF RA_CUSTOMER_MERGES.CUSTOMER_MERGE_HEADER_ID%TYPE

460: set_num NUMBER,
461: process_mode VARCHAR2) IS
462:
463: TYPE Merge_Header_ID_Type IS
464: TABLE OF RA_CUSTOMER_MERGES.CUSTOMER_MERGE_HEADER_ID%TYPE
465: INDEX BY BINARY_INTEGER;
466:
467: TYPE Cust_Account_ID_Type IS TABLE OF FII_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE
468: INDEX BY BINARY_INTEGER;

Line 490: RA_Customer_Merges M

486: CA.Cust_Account_ID,
487: CA.Account_Owner_Party_ID,
488: CA.Parent_Party_ID
489: FROM FII_Cust_Accounts CA,
490: RA_Customer_Merges M
491: WHERE CA.Cust_Account_ID = M.Duplicate_ID
492: AND M.Process_Flag = 'N'
493: AND M.Request_ID = Req_ID
494: AND M.Set_Number = Set_Num