DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PA_IMPLEMENTATIONS_ALL

Line 2658: pa_implementations_all imp

2654: /** Bug fix : 2347699 added this check to make sure that project is not cross charged **/
2655: /** BugFix : If grants and projects enables in the same ou then errors with no data found in cursors*/
2656: AND EXISTS (SELECT 1
2657: FROM pa_projects_all pp,
2658: pa_implementations_all imp
2659: WHERE pp.project_id = pobc.pa_project_id
2660: AND pp.org_id = imp.org_id
2661: AND imp.set_of_books_id = pobc.ledger_id )
2662: AND EXISTS ( SELECT 'Project Bdgt Ctrl enabled'

Line 2736: pa_implementations_all imp

2732: /** Bug fix : 2347699 added this check to make sure that project is not cross charged **/
2733: /** BugFix : If grants and projects enables in the same ou then errors with no data found in cursors*/
2734: AND EXISTS (SELECT 1
2735: FROM pa_projects_all pp,
2736: pa_implementations_all imp
2737: WHERE pp.project_id = apd.project_id
2738: AND pp.org_id = imp.org_id
2739: AND imp.set_of_books_id = apd.set_of_books_id )
2740: AND EXISTS ( SELECT 'Project Bdgt Ctrl enabled'

Line 8738: pa_implementations_all imp

8734: pa_projects_all pp,
8735: igc_cc_acct_lines igc,
8736: igc_cc_det_pf igcpf,
8737: igc_cc_headers_all igchead,
8738: pa_implementations_all imp
8739: WHERE igc.cc_header_id = gl.reference1
8740: AND igchead.cc_header_id = igc.cc_header_id
8741: AND igcpf.cc_det_pf_line_id = gl.reference4
8742: AND igc.cc_acct_line_id = igcpf.cc_acct_line_id

Line 9046: pa_implementations_all imp

9042: igc_cc_interface igci,
9043: igc_cc_acct_lines igc,
9044: igc_cc_headers_all igchead,
9045: gl_period_statuses gl,
9046: pa_implementations_all imp
9047: WHERE igc.cc_header_id = p_reference2
9048: AND p_reference1 = 'CC'
9049: AND igchead.cc_header_id = igc.cc_header_id
9050: AND igc.project_id IS NOT NULL

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

9059: AND trunc(igci.cc_transaction_date)
9060: between gl.start_date and gl.end_date
9061: AND nvl(pp.org_id, -99) = nvl(imp.org_id, -99)
9062: AND imp.set_of_books_id = (SELECT imp1.set_of_books_id
9063: FROM pa_implementations_all imp1 where org_id = pp.org_id)
9064: AND EXISTS ( select 'Project Bdgt Ctrl enabled'
9065: from pa_budget_types bdgttype
9066: ,pa_budgetary_control_options pbct
9067: where pbct.project_id = pp.project_id