APPS.CS_CH_ACCOUNT_MERGE_PKG dependencies on RA_CUSTOMER_MERGES

Line 92: ra_customer_merges m

88: ,ESTIMATE_DETAIL_ID
89: ,INVOICE_TO_ACCOUNT_ID
90: ,SHIP_TO_ACCOUNT_ID
91: FROM CS_ESTIMATE_DETAILS yt,
92: ra_customer_merges m
93: WHERE ( yt.INVOICE_TO_ACCOUNT_ID = m.DUPLICATE_ID
94: OR yt.SHIP_TO_ACCOUNT_ID = m.DUPLICATE_ID)
95: AND m.process_flag = 'N'
96: AND m.request_id = req_id

Line 106: from RA_CUSTOMER_MERGES RCM

102: WHERE cust_account_id = p_cust_account_id;
103:
104: CURSOR CUST_MERGE_CUR(req_id NUMBER, set_num NUMBER) IS
105: select CUSTOMER_ID, DUPLICATE_ID
106: from RA_CUSTOMER_MERGES RCM
107: Where rcm.request_id = req_id
108: And rcm.set_number = set_number
109: And rcm.process_flag = 'N';
110:

Line 112: g_customer_id RA_CUSTOMER_MERGES.CUSTOMER_ID%TYPE;

108: And rcm.set_number = set_number
109: And rcm.process_flag = 'N';
110:
111: l_profile_val VARCHAR2(30);
112: g_customer_id RA_CUSTOMER_MERGES.CUSTOMER_ID%TYPE;
113: g_duplicate_id RA_CUSTOMER_MERGES.DUPLICATE_ID%TYPE;
114:
115: g_cust_party_id HZ_PARTIES.PARTY_ID%TYPE;
116: g_dup_party_id HZ_PARTIES.PARTY_ID%TYPE;

Line 113: g_duplicate_id RA_CUSTOMER_MERGES.DUPLICATE_ID%TYPE;

109: And rcm.process_flag = 'N';
110:
111: l_profile_val VARCHAR2(30);
112: g_customer_id RA_CUSTOMER_MERGES.CUSTOMER_ID%TYPE;
113: g_duplicate_id RA_CUSTOMER_MERGES.DUPLICATE_ID%TYPE;
114:
115: g_cust_party_id HZ_PARTIES.PARTY_ID%TYPE;
116: g_dup_party_id HZ_PARTIES.PARTY_ID%TYPE;
117: