APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PA_BUDGET_TYPES

Line 2710: FROM pa_budget_types bdgttype

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'
2710: FROM pa_budget_types bdgttype
2711: ,pa_budgetary_control_options pbct
2712: WHERE pbct.project_id = pobc.pa_project_id
2713: AND pbct.BDGT_CNTRL_FLAG = 'Y'
2714: AND (pbct.EXTERNAL_BUDGET_CODE = 'GL' OR

Line 2788: FROM pa_budget_types bdgttype

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'
2788: FROM pa_budget_types bdgttype
2789: ,pa_budgetary_control_options pbct
2790: WHERE pbct.project_id = apd.project_id
2791: AND pbct.BDGT_CNTRL_FLAG = 'Y'
2792: AND (pbct.EXTERNAL_BUDGET_CODE = 'GL' OR

Line 2846: FROM pa_budget_types bdgttype

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'
2846: FROM pa_budget_types bdgttype
2847: ,pa_budgetary_control_options pbct
2848: WHERE pbct.project_id = apd.project_id
2849: AND pbct.BDGT_CNTRL_FLAG = 'Y'
2850: AND (pbct.EXTERNAL_BUDGET_CODE = 'GL' OR

Line 8456: Pa_Budget_Types bt,

8452: bv.budget_version_id,
8453: pm.entry_level_code
8454: FROM pa_tasks pt,
8455: pa_budget_versions bv,
8456: Pa_Budget_Types bt,
8457: pa_budgetary_control_options pbct,
8458: pa_budget_entry_methods pm
8459: WHERE pt.task_id = p_task_id
8460: AND bv.project_id = pt.project_id

Line 9136: from pa_budget_types bdgttype

9132: AND nvl(pp.org_id, -99) = nvl(imp.org_id, -99)
9133: AND imp.set_of_books_id = gl.ledger_Id
9134: AND EXISTS
9135: ( select 'Project Bdgt Ctrl enabled'
9136: from pa_budget_types bdgttype
9137: ,pa_budgetary_control_options pbct
9138: where pbct.project_id = pp.project_id
9139: and pbct.BDGT_CNTRL_FLAG = 'Y'
9140: and (pbct.EXTERNAL_BUDGET_CODE = 'GL'

Line 9358: from pa_budget_types bdgttype

9354: AND igc.project_id = pp.project_id
9355: AND igc.task_id = pkt.task_id
9356: AND pkt.project_id = pp.project_id
9357: AND EXISTS ( select 'Project Bdgt Ctrl enabled'
9358: from pa_budget_types bdgttype
9359: ,pa_budgetary_control_options pbct
9360: where pbct.project_id = pp.project_id
9361: and pbct.BDGT_CNTRL_FLAG = 'Y'
9362: and (pbct.EXTERNAL_BUDGET_CODE = 'GL'

Line 9453: from pa_budget_types bdgttype

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
9456: and pbct.BDGT_CNTRL_FLAG = 'Y'
9457: and pbct.EXTERNAL_BUDGET_CODE = 'CC'