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,
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: