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_FUNDS_CONTROL_PKG1 dependencies on PA_IMPLEMENTATIONS_ALL

Line 2705: pa_implementations_all imp

2701: /** Bug fix : 2347699 added this check to make sure that project is not cross charged **/
2702: /** BugFix : If grants and projects enables in the same ou then errors with no data found in cursors*/
2703: AND EXISTS (SELECT 1
2704: FROM pa_projects_all pp,
2705: pa_implementations_all imp
2706: WHERE pp.project_id = pobc.pa_project_id
2707: AND pp.org_id = imp.org_id
2708: AND imp.set_of_books_id = pobc.ledger_id )
2709: AND EXISTS ( SELECT 'Project Bdgt Ctrl enabled'

Line 2783: pa_implementations_all imp

2779: /** Bug fix : 2347699 added this check to make sure that project is not cross charged **/
2780: /** BugFix : If grants and projects enables in the same ou then errors with no data found in cursors*/
2781: AND EXISTS (SELECT 1
2782: FROM pa_projects_all pp,
2783: pa_implementations_all imp
2784: WHERE pp.project_id = apd.project_id
2785: AND pp.org_id = imp.org_id
2786: AND imp.set_of_books_id = apd.set_of_books_id )
2787: AND EXISTS ( SELECT 'Project Bdgt Ctrl enabled'

Line 2841: pa_implementations_all imp

2837: )
2838: )
2839: AND EXISTS (SELECT 1
2840: FROM pa_projects_all pp,
2841: pa_implementations_all imp
2842: WHERE pp.project_id = apd.project_id
2843: AND pp.org_id = imp.org_id
2844: AND imp.set_of_books_id = apd.set_of_books_id )
2845: AND EXISTS ( SELECT 'Project Bdgt Ctrl enabled'

Line 9123: pa_implementations_all imp

9119: pa_projects_all pp,
9120: igc_cc_acct_lines igc,
9121: igc_cc_det_pf igcpf,
9122: igc_cc_headers_all igchead,
9123: pa_implementations_all imp
9124: WHERE igc.cc_header_id = gl.reference1
9125: AND igchead.cc_header_id = igc.cc_header_id
9126: AND igcpf.cc_det_pf_line_id = gl.reference4
9127: AND igc.cc_acct_line_id = igcpf.cc_acct_line_id

Line 9434: pa_implementations_all imp

9430: igc_cc_interface igci,
9431: igc_cc_acct_lines igc,
9432: igc_cc_headers_all igchead,
9433: gl_period_statuses gl,
9434: pa_implementations_all imp
9435: WHERE igc.cc_header_id = p_reference2
9436: AND p_reference1 = 'CC'
9437: AND igchead.cc_header_id = igc.cc_header_id
9438: AND igc.project_id IS NOT NULL

Line 9451: FROM pa_implementations_all imp1 where org_id = pp.org_id)

9447: AND trunc(igci.cc_transaction_date)
9448: between gl.start_date and gl.end_date
9449: AND nvl(pp.org_id, -99) = nvl(imp.org_id, -99)
9450: AND imp.set_of_books_id = (SELECT imp1.set_of_books_id
9451: FROM pa_implementations_all imp1 where org_id = pp.org_id)
9452: AND EXISTS ( select 'Project Bdgt Ctrl enabled'
9453: from pa_budget_types bdgttype
9454: ,pa_budgetary_control_options pbct
9455: where pbct.project_id = pp.project_id