DBA Data[Home] [Help]

APPS.PAP_CMERGE dependencies on PA_IMPLEMENTATIONS_ALL

Line 313: SELECT count(*) INTO var_count2 FROM pa_implementations_all

309: WHERE customer_id = var_dup_id
310: AND project_id NOT IN (
311: SELECT project_id FROM pa_projects);
312:
313: SELECT count(*) INTO var_count2 FROM pa_implementations_all
314: WHERE customer_id = var_dup_id
315: AND org_id NOT IN (
316: SELECT DISTINCT org_id FROM pa_projects);
317:

Line 1379: 'PA_IMPLEMENTATIONS_ALL',

1375: LAST_UPDATE_LOGIN,
1376: LAST_UPDATE_DATE,
1377: LAST_UPDATED_BY)
1378: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1379: 'PA_IMPLEMENTATIONS_ALL',
1380: RACM.CUSTOMER_MERGE_HEADER_ID,
1381: PI.ORG_ID,
1382: PI.CUSTOMER_ID,
1383: RACM.CUSTOMER_ID,