APPS.PAP_CMERGE dependencies on PA_AGREEMENTS_ALL

Line 288: SELECT count(*) INTO var_count2 FROM pa_agreements_all

284: SELECT DISTINCT org_id FROM pa_projects);
285:
286: var_count1 := var_count1 + var_count2;
287:
288: SELECT count(*) INTO var_count2 FROM pa_agreements_all
289: WHERE customer_id = var_dup_id
290: AND org_id NOT IN (
291: SELECT DISTINCT org_id FROM pa_projects);
292: