APPS.PAP_CMERGE dependencies on PA_PROJ_RETN_BILL_RULES

Line 181: SELECT CUSTOMER_ID FROM pa_proj_retn_bill_rules PA

177: AND RACM.SET_NUMBER = set_no )
178: FOR UPDATE NOWAIT;
179: --
180: CURSOR cursor_lock_8 IS
181: SELECT CUSTOMER_ID FROM pa_proj_retn_bill_rules PA
182: WHERE
183: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
184: FROM RA_CUSTOMER_MERGES RACM
185: WHERE RACM.PROCESS_FLAG = 'N'

Line 276: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_BILL_RULES', FALSE );

272: open cursor_lock_7;
273: close cursor_lock_7;
274: --
275: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
276: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_BILL_RULES', FALSE );
277: --
278: open cursor_lock_8;
279: close cursor_lock_8;
280: --

Line 1507: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_BILL_RULES' );

1503: --
1504: -- update log file to indicate the table being updated. For bug# 1676538
1505: --
1506: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1507: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_BILL_RULES' );
1508: --
1509: -- update pa_proj_retn_bill_rules for customer_id (duplicate_id ).
1510: --
1511: IF g_audit_profile='Y' THEN

Line 1509: -- update pa_proj_retn_bill_rules for customer_id (duplicate_id ).

1505: --
1506: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1507: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_BILL_RULES' );
1508: --
1509: -- update pa_proj_retn_bill_rules for customer_id (duplicate_id ).
1510: --
1511: IF g_audit_profile='Y' THEN
1512:
1513: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1528: 'PA_PROJ_RETN_BILL_RULES',

1524: LAST_UPDATE_LOGIN,
1525: LAST_UPDATE_DATE,
1526: LAST_UPDATED_BY)
1527: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1528: 'PA_PROJ_RETN_BILL_RULES',
1529: RACM.CUSTOMER_MERGE_HEADER_ID,
1530: PB. RETN_BILLING_RULE_ID,
1531: PB.CUSTOMER_ID,
1532: RACM.CUSTOMER_ID,

Line 1540: FROM PA_PROJ_RETN_BILL_RULES PB,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

1536: hz_utility_pub.CREATION_DATE,
1537: hz_utility_pub.LAST_UPDATE_LOGIN,
1538: hz_utility_pub.LAST_UPDATE_DATE,
1539: hz_utility_pub.LAST_UPDATED_BY
1540: FROM PA_PROJ_RETN_BILL_RULES PB,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1541: CUSTOMER_ID,
1542: DUPLICATE_ID FROM RA_CUSTOMER_MERGES
1543: WHERE PROCESS_FLAG ='N'
1544: AND SET_NUMBER = set_no

Line 1555: UPDATE PA_PROJ_RETN_BILL_RULES PB

1551:
1552:
1553: END IF;
1554:
1555: UPDATE PA_PROJ_RETN_BILL_RULES PB
1556: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1557: FROM RA_CUSTOMER_MERGES RACM
1558: WHERE RACM.DUPLICATE_ID = PB.CUSTOMER_ID
1559: AND RACM.PROCESS_FLAG = 'N'