APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PA_BUDGET_TYPES

Line 2663: FROM pa_budget_types bdgttype

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'
2663: FROM pa_budget_types bdgttype
2664: ,pa_budgetary_control_options pbct
2665: WHERE pbct.project_id = pobc.pa_project_id
2666: AND pbct.BDGT_CNTRL_FLAG = 'Y'
2667: AND (pbct.EXTERNAL_BUDGET_CODE = 'GL' OR

Line 2741: FROM pa_budget_types bdgttype

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'
2741: FROM pa_budget_types bdgttype
2742: ,pa_budgetary_control_options pbct
2743: WHERE pbct.project_id = apd.project_id
2744: AND pbct.BDGT_CNTRL_FLAG = 'Y'
2745: AND (pbct.EXTERNAL_BUDGET_CODE = 'GL' OR

Line 8082: Pa_Budget_Types bt,

8078: bv.budget_version_id,
8079: pm.entry_level_code
8080: FROM pa_tasks pt,
8081: pa_budget_versions bv,
8082: Pa_Budget_Types bt,
8083: pa_budgetary_control_options pbct,
8084: pa_budget_entry_methods pm
8085: WHERE pt.task_id = p_task_id
8086: AND bv.project_id = pt.project_id

Line 8751: from pa_budget_types bdgttype

8747: AND nvl(pp.org_id, -99) = nvl(imp.org_id, -99)
8748: AND imp.set_of_books_id = gl.ledger_Id
8749: AND EXISTS
8750: ( select 'Project Bdgt Ctrl enabled'
8751: from pa_budget_types bdgttype
8752: ,pa_budgetary_control_options pbct
8753: where pbct.project_id = pp.project_id
8754: and pbct.BDGT_CNTRL_FLAG = 'Y'
8755: and (pbct.EXTERNAL_BUDGET_CODE = 'GL'

Line 8970: from pa_budget_types bdgttype

8966: AND igc.project_id = pp.project_id
8967: AND igc.task_id = pkt.task_id
8968: AND pkt.project_id = pp.project_id
8969: AND EXISTS ( select 'Project Bdgt Ctrl enabled'
8970: from pa_budget_types bdgttype
8971: ,pa_budgetary_control_options pbct
8972: where pbct.project_id = pp.project_id
8973: and pbct.BDGT_CNTRL_FLAG = 'Y'
8974: and (pbct.EXTERNAL_BUDGET_CODE = 'GL'

Line 9065: from pa_budget_types bdgttype

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