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.OKE_FUNDING_UTIL_PKG dependencies on PA_PROJECTS_ALL

Line 845: pa_projects_all p

841: cursor c_cust is
842: select count(p.project_id),
843: p.segment1
844: from pa_project_customers c,
845: pa_projects_all p
846: where p.project_id = x_project_id
847: and p.project_id = c.project_id
848: and c.customer_bill_split <> 0
849: group by p.project_id, p.segment1;

Line 1191: from pa_projects_all p,

1187: FUNCTION get_project_currency(x_project_id number) return varchar2
1188: is
1189: cursor c_currency is
1190: select currency_code
1191: from pa_projects_all p,
1192: pa_implementations_all i,
1193: gl_sets_of_books g
1194: where p.project_id = x_project_id
1195: and nvl(p.org_id, -99) = nvl(i.org_id, -99)

Line 1540: from pa_projects_all p,

1536:
1537: cursor c_min_unit is
1538: select nvl(minimum_accountable_unit, power(10, -1 * precision)),
1539: p.projfunc_currency_code
1540: from pa_projects_all p,
1541: fnd_currencies f
1542: where project_id = x_project_id
1543: and f.currency_code = p.projfunc_currency_code;
1544: