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