APPS.PAP_CMERGE dependencies on PA_AGREEMENTS

Line 154: SELECT CUSTOMER_ID FROM pa_agreements PA

150: AND RACM.SET_NUMBER = set_no )
151: FOR UPDATE NOWAIT;
152: --
153: CURSOR cursor_lock_5 IS
154: SELECT CUSTOMER_ID FROM pa_agreements PA
155: WHERE
156: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
157: FROM RA_CUSTOMER_MERGES RACM
158: WHERE RACM.PROCESS_FLAG = 'N'

Line 257: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_AGREEMENTS', FALSE );

253: open cursor_lock_4;
254: close cursor_lock_4;
255: --
256: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
257: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_AGREEMENTS', FALSE );
258: --
259: open cursor_lock_5;
260: close cursor_lock_5;
261: --

Line 320: SELECT count(*) INTO var_count2 FROM pa_agreements_all

316: SELECT DISTINCT org_id FROM pa_projects);
317:
318: var_count1 := var_count1 + var_count2;
319:
320: SELECT count(*) INTO var_count2 FROM pa_agreements_all
321: WHERE customer_id = var_dup_id
322: AND org_id NOT IN (
323: SELECT DISTINCT org_id FROM pa_projects);
324:

Line 1664: -- update pa_agreements for customer_id only.

1660: total_record_upd_count := 0;
1661:
1662: /* END Added by sbsivara for retention related tables */
1663: --
1664: -- update pa_agreements for customer_id only.
1665: --
1666: PAP_CMERGE_BB1.MERGE_PA_AGREEMENTS( req_id, set_no );
1667: --
1668: -- update pa_project_contacts for customer_id only.

Line 1666: PAP_CMERGE_BB1.MERGE_PA_AGREEMENTS( req_id, set_no );

1662: /* END Added by sbsivara for retention related tables */
1663: --
1664: -- update pa_agreements for customer_id only.
1665: --
1666: PAP_CMERGE_BB1.MERGE_PA_AGREEMENTS( req_id, set_no );
1667: --
1668: -- update pa_project_contacts for customer_id only.
1669: --
1670: PAP_CMERGE_BB2.MERGE_PA_PROJECT_CONTACTS( req_id, set_no );