APPS.CSP_CMERGE_BB5 dependencies on RA_CUSTOMER_MERGES

Line 91: FROM CS_MASS_NOTIFICATION_TXNS_TEMP yt, RA_CUSTOMER_MERGES RACM

87: number_of_rows NUMBER;
88:
89: Cursor LOCK_CUSTOMER_ID ( req_id NUMBER, set_number NUMBER ) IS
90: SELECT yt.customer_id
91: FROM CS_MASS_NOTIFICATION_TXNS_TEMP yt, RA_CUSTOMER_MERGES RACM
92: WHERE
93: yt.customer_id IN ( SELECT RACM.DUPLICATE_ID
94: FROM RA_CUSTOMER_MERGES RACM
95: WHERE RACM.PROCESS_FLAG = 'N'

Line 94: FROM RA_CUSTOMER_MERGES RACM

90: SELECT yt.customer_id
91: FROM CS_MASS_NOTIFICATION_TXNS_TEMP yt, RA_CUSTOMER_MERGES RACM
92: WHERE
93: yt.customer_id IN ( SELECT RACM.DUPLICATE_ID
94: FROM RA_CUSTOMER_MERGES RACM
95: WHERE RACM.PROCESS_FLAG = 'N'
96: AND RACM.REQUEST_ID = req_id
97: AND RACM.SET_NUMBER = set_number )
98: FOR UPDATE NOWAIT;

Line 120: FROM RA_CUSTOMER_MERGES RACM

116:
117: UPDATE CS_MASS_NOTIFICATION_TXNS_TEMP yt
118: SET
119: yt.customer_id = ( SELECT DISTINCT RACM.CUSTOMER_ID
120: FROM RA_CUSTOMER_MERGES RACM
121: WHERE yt.customer_id = DUPLICATE_ID
122: AND RACM.PROCESS_FLAG = 'N'
123: AND RACM.REQUEST_ID = req_id
124: AND RACM.SET_NUMBER = set_number )

Line 127: FROM RA_CUSTOMER_MERGES RACM

123: AND RACM.REQUEST_ID = req_id
124: AND RACM.SET_NUMBER = set_number )
125: WHERE
126: yt.customer_id IN ( SELECT RACM.DUPLICATE_ID
127: FROM RA_CUSTOMER_MERGES RACM
128: WHERE RACM.PROCESS_FLAG = 'N'
129: AND RACM.REQUEST_ID = req_id
130: AND RACM.SET_NUMBER = set_number );
131: