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.PA_RETN_BILLING_PKG dependencies on PA_PROJECT_TYPES

Line 1314: from pa_project_types pt

1310: OR pc.customer_id = p_customer_id
1311: )
1312: AND (nvl(p_project_type_id, 0) = 0
1313: OR EXISTS ( select null
1314: from pa_project_types pt
1315: where pr.project_type = pt.project_type
1316: and pt.project_type_id = p_project_type_id)
1317: )
1318: AND ( nvl(p_project_org_id,0) = 0

Line 2009: FROM pa_projects pr, pa_project_types t

2005: p_start_proj_number IN VARCHAR2,
2006: p_end_proj_number IN VARCHAR2) IS
2007: CURSOR cur_select_projects IS
2008: SELECT pr.project_id project_id
2009: FROM pa_projects pr, pa_project_types t
2010: WHERE NOT EXISTS (SELECT null
2011: FROM pa_draft_invoices_all di
2012: WHERE di.request_id = p_request_id
2013: AND di.project_id = pr.project_id