APPS.PAP_CMERGE dependencies on PA_PROJECT_CONTACTS

Line 113: SELECT CUSTOMER_ID FROM pa_project_contacts PC

109: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' )
110: FOR UPDATE NOWAIT;
111: --
112: CURSOR cursor_lock_4 IS
113: SELECT CUSTOMER_ID FROM pa_project_contacts PC
114: WHERE
115: PC.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
116: FROM RA_CUSTOMER_MERGES RACM
117: WHERE RACM.PROCESS_FLAG = 'N'

Line 219: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJECT_CONTACTS', FALSE );

215: open cursor_lock_3;
216: close cursor_lock_3;
217: --
218: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
219: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJECT_CONTACTS', FALSE );
220: --
221: open cursor_lock_4;
222: close cursor_lock_4;
223: --

Line 295: SELECT count(*) INTO var_count2 FROM pa_project_contacts

291: SELECT DISTINCT org_id FROM pa_projects);
292:
293: var_count1 := var_count1 + var_count2;
294:
295: SELECT count(*) INTO var_count2 FROM pa_project_contacts
296: WHERE customer_id = var_dup_id
297: AND project_id NOT IN (
298: SELECT project_id FROM pa_projects);
299:

Line 1630: -- update pa_project_contacts for customer_id only.

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 );
1633: --
1634: --

Line 1632: PAP_CMERGE_BB2.MERGE_PA_PROJECT_CONTACTS( req_id, set_no );

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 );
1633: --
1634: --
1635: <>
1636: --