DBA Data[Home] [Help]

APPS.PA_BUDGET_FUND_PKG dependencies on PA_BUDGET_TYPES

Line 922: l_budget_amount_code PA_BUDGET_TYPES.Budget_amount_code%TYPE;

918: l_external_budget_code PA_BUDGETARY_CONTROL_OPTIONS.External_budget_code%TYPE ;
919: l_encumbrance_Type_Id PA_BUDGETARY_CONTROL_OPTIONS.Encumbrance_Type_Id%TYPE ;
920: l_bdgt_cntrl_flag PA_BUDGETARY_CONTROL_OPTIONS.Bdgt_cntrl_flag%TYPE ;
921: l_budget_type PA_BUDGETARY_CONTROL_OPTIONS.budget_type_code%TYPE ;
922: l_budget_amount_code PA_BUDGET_TYPES.Budget_amount_code%TYPE;
923: l_budget_entry_level_code PA_Budget_Entry_Methods.entry_level_code%TYPE;
924:
925: l_dual_bdgt_cntrl_flag VARCHAR2(1);
926: l_cc_budget_version_id NUMBER;

Line 966: PA_BUDGET_TYPES PBT,

962: PBT.budget_amount_code,
963: BEM.entry_level_code
964: From PA_BUDGETARY_CONTROL_OPTIONS PBCO ,
965: PA_BUDGET_VERSIONS PBV,
966: PA_BUDGET_TYPES PBT,
967: PA_BUDGET_ENTRY_METHODS BEM
968: WHERE PBCO.Project_Id = p_project_id
969: AND PBV.Budget_version_id = p_Budget_version_id
970: AND PBV.Budget_Type_Code = PBCO.Budget_Type_Code

Line 2817: PA_BUDGET_TYPES PBT

2813: l_project_id,
2814: l_budget_type_code
2815: from PA_BUDGETARY_CONTROL_OPTIONS PBCO ,
2816: PA_BUDGET_VERSIONS PBV,
2817: PA_BUDGET_TYPES PBT
2818: where PBV.Budget_version_id = p_budget_version_id
2819: and PBCO.Budget_Type_Code = PBV.Budget_Type_Code
2820: and PBCO.project_id = PBV.project_id
2821: and PBT.Budget_type_code = PBV.Budget_type_code;