APPS.PAP_CMERGE dependencies on PA_PROJ_RETN_BILL_RULES

Line 149: SELECT CUSTOMER_ID FROM pa_proj_retn_bill_rules PA

145: AND RACM.SET_NUMBER = set_no )
146: FOR UPDATE NOWAIT;
147: --
148: CURSOR cursor_lock_8 IS
149: SELECT CUSTOMER_ID FROM pa_proj_retn_bill_rules PA
150: WHERE
151: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
152: FROM RA_CUSTOMER_MERGES RACM
153: WHERE RACM.PROCESS_FLAG = 'N'

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

240: open cursor_lock_7;
241: close cursor_lock_7;
242: --
243: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
244: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_BILL_RULES', FALSE );
245: --
246: open cursor_lock_8;
247: close cursor_lock_8;
248: --

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

1465: --
1466: -- update log file to indicate the table being updated. For bug# 1676538
1467: --
1468: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1469: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_BILL_RULES' );
1470: --
1471: -- update pa_proj_retn_bill_rules for customer_id (duplicate_id ).
1472: --
1473: IF g_audit_profile='Y' THEN

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

1467: --
1468: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1469: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_BILL_RULES' );
1470: --
1471: -- update pa_proj_retn_bill_rules for customer_id (duplicate_id ).
1472: --
1473: IF g_audit_profile='Y' THEN
1474:
1475: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1490: 'PA_PROJ_RETN_BILL_RULES',

1486: LAST_UPDATE_LOGIN,
1487: LAST_UPDATE_DATE,
1488: LAST_UPDATED_BY)
1489: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1490: 'PA_PROJ_RETN_BILL_RULES',
1491: RACM.CUSTOMER_MERGE_HEADER_ID,
1492: PB. RETN_BILLING_RULE_ID,
1493: PB.CUSTOMER_ID,
1494: RACM.CUSTOMER_ID,

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

1498: hz_utility_pub.CREATION_DATE,
1499: hz_utility_pub.LAST_UPDATE_LOGIN,
1500: hz_utility_pub.LAST_UPDATE_DATE,
1501: hz_utility_pub.LAST_UPDATED_BY
1502: FROM PA_PROJ_RETN_BILL_RULES PB,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1503: CUSTOMER_ID,
1504: DUPLICATE_ID FROM RA_CUSTOMER_MERGES
1505: WHERE PROCESS_FLAG ='N'
1506: AND SET_NUMBER = set_no

Line 1517: UPDATE PA_PROJ_RETN_BILL_RULES PB

1513:
1514:
1515: END IF;
1516:
1517: UPDATE PA_PROJ_RETN_BILL_RULES PB
1518: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1519: FROM RA_CUSTOMER_MERGES RACM
1520: WHERE RACM.DUPLICATE_ID = PB.CUSTOMER_ID
1521: AND RACM.PROCESS_FLAG = 'N'