APPS.PAP_CMERGE_BB1 dependencies on RA_CUSTOMER_MERGES

Line 19: FROM RA_CUSTOMER_MERGES RACM

15: agmt_old_customer_id := NULL;
16: --
17: SELECT DISTINCT RACM.CUSTOMER_ID, RACM.DUPLICATE_ID INTO
18: agmt_new_customer_id, agmt_old_customer_id
19: FROM RA_CUSTOMER_MERGES RACM
20: WHERE RACM.DUPLICATE_ID = var_agmt_customer_id
21: AND RACM.PROCESS_FLAG = 'N'
22: AND RACM.SET_NUMBER = set_no;
23: --

Line 71: cust_merge_head_id IN ra_customer_merges.CUSTOMER_MERGE_HEADER_ID%TYPE)/*Added for TCA AUDIT */

67: var_agmt_agreement_type IN pa_agreements.agreement_type%TYPE,
68: seq_index IN NUMBER,
69: duplicate_index_value OUT NOCOPY BOOLEAN ,/*file.sql.39*/
70: request_id IN Number,
71: cust_merge_head_id IN ra_customer_merges.CUSTOMER_MERGE_HEADER_ID%TYPE)/*Added for TCA AUDIT */
72: --
73: RETURN BOOLEAN IS
74: --
75: /* Commented for enhancement 1593520

Line 194: FROM pa_agreements ag,ra_customer_merges RACM --bug3891382

190: ag.AGREEMENT_NUM,
191: ag.AGREEMENT_TYPE,
192: RACM.CUSTOMER_ID,
193: RACM.CUSTOMER_MERGE_HEADER_ID
194: FROM pa_agreements ag,ra_customer_merges RACM --bug3891382
195: WHERE RACM.DUPLICATE_ID = AG.CUSTOMER_ID
196: AND RACM.PROCESS_FLAG = 'N'
197: AND RACM.SET_NUMBER = set_no
198: AND RACM.CUSTOMER_ID <> RACM.DUPLICATE_ID;

Line 202: var_racm_customer_id ra_customer_merges.customer_id%TYPE;/*Added for TCA AUDIT */

198: AND RACM.CUSTOMER_ID <> RACM.DUPLICATE_ID;
199: --
200:
201: var_agmt_customer_id pa_agreements.customer_id%TYPE;
202: var_racm_customer_id ra_customer_merges.customer_id%TYPE;/*Added for TCA AUDIT */
203: var_cust_merge_header_id ra_customer_merges.CUSTOMER_MERGE_HEADER_ID%TYPE;/*Added for TCA AUDIT */
204: var_agmt_agreement_id pa_agreements.agreement_id%TYPE; /* Added for Tca Audit*/
205: var_agmt_agreement_num pa_agreements.agreement_num%TYPE;
206: var_agmt_agreement_type pa_agreements.agreement_type%TYPE;

Line 203: var_cust_merge_header_id ra_customer_merges.CUSTOMER_MERGE_HEADER_ID%TYPE;/*Added for TCA AUDIT */

199: --
200:
201: var_agmt_customer_id pa_agreements.customer_id%TYPE;
202: var_racm_customer_id ra_customer_merges.customer_id%TYPE;/*Added for TCA AUDIT */
203: var_cust_merge_header_id ra_customer_merges.CUSTOMER_MERGE_HEADER_ID%TYPE;/*Added for TCA AUDIT */
204: var_agmt_agreement_id pa_agreements.agreement_id%TYPE; /* Added for Tca Audit*/
205: var_agmt_agreement_num pa_agreements.agreement_num%TYPE;
206: var_agmt_agreement_type pa_agreements.agreement_type%TYPE;
207: -- agmt_new_customer_id pa_agreements.customer_id%TYPE;