APPS.PA_BILLING_AMOUNT dependencies on PA_BUDGET_VERSIONS

Line 1078: l_cost_budget_version_id pa_budget_versions.budget_version_id%type;

1074: X_rev_budget out NOCOPY REAL, --File.Sql.39 bug 4440895
1075: X_cost_budget out NOCOPY REAL , --File.Sql.39 bug 4440895
1076: X_err_msg out NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1077: as
1078: l_cost_budget_version_id pa_budget_versions.budget_version_id%type;
1079: l_rev_budget_version_id pa_budget_versions.budget_version_id%type;
1080: l_quantity_total Real;
1081: l_raw_cost_total Real;
1082: l_burdened_cost_total Real;

Line 1079: l_rev_budget_version_id pa_budget_versions.budget_version_id%type;

1075: X_cost_budget out NOCOPY REAL , --File.Sql.39 bug 4440895
1076: X_err_msg out NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1077: as
1078: l_cost_budget_version_id pa_budget_versions.budget_version_id%type;
1079: l_rev_budget_version_id pa_budget_versions.budget_version_id%type;
1080: l_quantity_total Real;
1081: l_raw_cost_total Real;
1082: l_burdened_cost_total Real;
1083: l_err_code Number;

Line 1122: FROM pa_budget_versions v

1118: /* Added for Fin plan impact */
1119: BEGIN
1120: SELECT v.budget_version_id
1121: INTO l_cost_budget_version_id
1122: FROM pa_budget_versions v
1123: WHERE v.project_id = X_project_id
1124: AND v.current_flag = 'Y'
1125: AND v.budget_status_code = 'B'
1126: AND v.version_type IN ('COST','ALL');

Line 1134: FROM pa_budget_versions pbv

1130:
1131: c := 10;
1132: SELECT budget_version_id
1133: INTO l_cost_budget_version_id
1134: FROM pa_budget_versions pbv
1135: WHERE project_id = X_project_id
1136: AND budget_type_code = 'AC'
1137: AND budget_status_code = 'B'
1138: AND current_flag = 'Y';

Line 1149: FROM pa_budget_versions v

1145: /* Added for Fin plan impact */
1146: BEGIN
1147: SELECT v.budget_version_id
1148: INTO l_rev_budget_version_id
1149: FROM pa_budget_versions v
1150: WHERE v.project_id = X_project_id
1151: AND v.current_flag = 'Y'
1152: AND v.budget_status_code = 'B'
1153: AND v.version_type IN ('REVENUE','ALL')

Line 1162: FROM pa_budget_versions pbv

1158: c := 20;
1159:
1160: SELECT budget_version_id
1161: INTO l_rev_budget_version_id
1162: FROM pa_budget_versions pbv
1163: WHERE project_id = X_project_id
1164: AND budget_type_code = 'AR'
1165: AND budget_status_code = 'B'
1166: AND current_flag = 'Y';