DBA Data[Home] [Help]

APPS.PAP_CMERGE_BB2 dependencies on PA_PROJECTS

Line 187: AND EXISTS ( SELECT NULL FROM PA_PROJECTS

183: AND RACM.SET_NUMBER = set_no
184: AND RACM.CUSTOMER_ID <> RACM.DUPLICATE_ID
185: /* Bug 3891382. Added the condition so that the cursor picks projects specific to the
186: org_id where customer merge has taken place. */
187: AND EXISTS ( SELECT NULL FROM PA_PROJECTS
188: WHERE PROJECT_ID = PC.PROJECT_ID );
189:
190: CURSOR cursor_4 IS SELECT DISTINCT pc.project_id,
191: PC.CUSTOMER_ID,

Line 204: AND EXISTS ( SELECT NULL FROM PA_PROJECTS

200: AND RACM.SET_NUMBER = set_no
201: AND RACM.CUSTOMER_ID <> RACM.DUPLICATE_ID
202: /* Bug 3891382. Added the condition so that the cursor picks projects specific to the
203: org_id where customer merge has taken place. */
204: AND EXISTS ( SELECT NULL FROM PA_PROJECTS
205: WHERE PROJECT_ID = PC.PROJECT_ID );
206:
207: --
208: