eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAP_CMERGE dependencies on PA_AGREEMENTS_ALL

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

316: SELECT DISTINCT org_id FROM pa_projects);
317:
318: var_count1 := var_count1 + var_count2;
319:
320: SELECT count(*) INTO var_count2 FROM pa_agreements_all
321: WHERE customer_id = var_dup_id
322: AND org_id NOT IN (
323: SELECT DISTINCT org_id FROM pa_projects);
324: