DBA Data[Home] [Help]

APPS.PA_CC_ENC_IMPORT_FCK dependencies on PA_BUDGETARY_CONTROL_OPTIONS

Line 44: from pa_budgetary_control_options pbct

40: select 'Y'
41: into l_budget_control_flag
42: FROM DUAL
43: WHERE EXISTS ( select null
44: from pa_budgetary_control_options pbct
45: ,pa_budget_types bv
46: where pbct.project_id = p_project_id
47: AND pbct.BDGT_CNTRL_FLAG = 'Y'
48: AND pbct.BUDGET_TYPE_CODE = bv.budget_type_code

Line 101: ,pa_budgetary_control_options pbct

97: SELECT max(pbv.budget_version_id)
98: INTO l_budget_version_id
99: FROM pa_budget_versions pbv
100: ,pa_budget_types bdgttype
101: ,pa_budgetary_control_options pbct
102: WHERE pbv.project_id = p_project_id
103: AND pbv.current_flag = 'Y'
104: AND pbv.budget_status_code = 'B'
105: AND bdgttype.budget_type_code = pbv.budget_type_code