APPS.PAP_CMERGE dependencies on PA_AGREEMENTS

Line 122: SELECT CUSTOMER_ID FROM pa_agreements PA

118: AND RACM.SET_NUMBER = set_no )
119: FOR UPDATE NOWAIT;
120: --
121: CURSOR cursor_lock_5 IS
122: SELECT CUSTOMER_ID FROM pa_agreements PA
123: WHERE
124: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
125: FROM RA_CUSTOMER_MERGES RACM
126: WHERE RACM.PROCESS_FLAG = 'N'

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

221: open cursor_lock_4;
222: close cursor_lock_4;
223: --
224: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
225: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_AGREEMENTS', FALSE );
226: --
227: open cursor_lock_5;
228: close cursor_lock_5;
229: --

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

284: SELECT DISTINCT org_id FROM pa_projects);
285:
286: var_count1 := var_count1 + var_count2;
287:
288: SELECT count(*) INTO var_count2 FROM pa_agreements_all
289: WHERE customer_id = var_dup_id
290: AND org_id NOT IN (
291: SELECT DISTINCT org_id FROM pa_projects);
292:

Line 1626: -- update pa_agreements for customer_id only.

1622: total_record_upd_count := 0;
1623:
1624: /* END Added by sbsivara for retention related tables */
1625: --
1626: -- update pa_agreements for customer_id only.
1627: --
1628: PAP_CMERGE_BB1.MERGE_PA_AGREEMENTS( req_id, set_no );
1629: --
1630: -- update pa_project_contacts for customer_id only.

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

1624: /* END Added by sbsivara for retention related tables */
1625: --
1626: -- update pa_agreements for customer_id only.
1627: --
1628: PAP_CMERGE_BB1.MERGE_PA_AGREEMENTS( req_id, set_no );
1629: --
1630: -- update pa_project_contacts for customer_id only.
1631: --
1632: PAP_CMERGE_BB2.MERGE_PA_PROJECT_CONTACTS( req_id, set_no );