APPS.CS_SR_ACCOUNT_MERGE_PKG dependencies on RA_CUSTOMER_MERGES

Line 105: ra_customer_merges m

101: ,BILL_TO_ACCOUNT_ID
102: ,SHIP_TO_ACCOUNT_ID
103: ,LAST_UPDATE_PROGRAM_CODE
104: FROM CS_INCIDENTS_ALL_B yt,
105: ra_customer_merges m
106: WHERE ( yt.ACCOUNT_ID = m.DUPLICATE_ID
107: OR yt.BILL_TO_ACCOUNT_ID = m.DUPLICATE_ID
108: OR yt.SHIP_TO_ACCOUNT_ID = m.DUPLICATE_ID)
109: AND m.process_flag = 'N'

Line 120: from RA_CUSTOMER_MERGES RCM

116: WHERE cust_account_id = p_cust_account_id;
117:
118: CURSOR CUST_MERGE_CUR(req_id NUMBER, set_num NUMBER) IS
119: select CUSTOMER_ID, DUPLICATE_ID
120: from RA_CUSTOMER_MERGES RCM
121: Where rcm.request_id = req_id
122: And rcm.set_number = set_number
123: And rcm.process_flag = 'N';
124:

Line 126: g_customer_id RA_CUSTOMER_MERGES.CUSTOMER_ID%TYPE;

122: And rcm.set_number = set_number
123: And rcm.process_flag = 'N';
124:
125: l_profile_val VARCHAR2(30);
126: g_customer_id RA_CUSTOMER_MERGES.CUSTOMER_ID%TYPE;
127: g_duplicate_id RA_CUSTOMER_MERGES.DUPLICATE_ID%TYPE;
128:
129: g_cust_party_id HZ_PARTIES.PARTY_ID%TYPE;
130: g_dup_party_id HZ_PARTIES.PARTY_ID%TYPE;

Line 127: g_duplicate_id RA_CUSTOMER_MERGES.DUPLICATE_ID%TYPE;

123: And rcm.process_flag = 'N';
124:
125: l_profile_val VARCHAR2(30);
126: g_customer_id RA_CUSTOMER_MERGES.CUSTOMER_ID%TYPE;
127: g_duplicate_id RA_CUSTOMER_MERGES.DUPLICATE_ID%TYPE;
128:
129: g_cust_party_id HZ_PARTIES.PARTY_ID%TYPE;
130: g_dup_party_id HZ_PARTIES.PARTY_ID%TYPE;
131: