DBA Data[Home] [Help]

APPS.PA_MC_BILLING_PVT dependencies on PA_BUDGET_VERSIONS

Line 146: FROM pa_budget_versions pbv

142: BEGIN
143:
144: SELECT budget_version_id
145: INTO l_cost_budget_version_id
146: FROM pa_budget_versions pbv
147: WHERE project_id = p_project_id
148: AND budget_type_code = l_cost_budget_type_code
149: AND budget_status_code = 'B'
150: AND current_flag = 'Y';

Line 168: FROM pa_budget_versions pbv

164: BEGIN
165:
166: SELECT budget_version_id
167: INTO l_rev_budget_version_id
168: FROM pa_budget_versions pbv
169: WHERE project_id = p_project_id
170: AND budget_type_code = l_rev_budget_type_code
171: AND budget_status_code = 'B'
172: AND current_flag = 'Y';