DBA Data[Home] [Help]

APPS.PAP_CMERGE dependencies on PA_IMPLEMENTATIONS_ALL

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

277: WHERE customer_id = var_dup_id
278: AND project_id NOT IN (
279: SELECT project_id FROM pa_projects);
280:
281: SELECT count(*) INTO var_count2 FROM pa_implementations_all
282: WHERE customer_id = var_dup_id
283: AND org_id NOT IN (
284: SELECT DISTINCT org_id FROM pa_projects);
285:

Line 1341: 'PA_IMPLEMENTATIONS_ALL',

1337: LAST_UPDATE_LOGIN,
1338: LAST_UPDATE_DATE,
1339: LAST_UPDATED_BY)
1340: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1341: 'PA_IMPLEMENTATIONS_ALL',
1342: RACM.CUSTOMER_MERGE_HEADER_ID,
1343: PI.ORG_ID,
1344: PI.CUSTOMER_ID,
1345: RACM.CUSTOMER_ID,