1163: INTO
1164: xCstForecastPlanTypeId
1165: ,xOrigCstForecastVersionId
1166: FROM
1167: pa_budget_versions pbv
1168: , pa_budget_versions orig_pbv
1169: , pa_fin_plan_types_b orig_pfptb
1170: -- , pa_fin_plan_types_tl orig_pfptt
1171: WHERE 1=1
1164: xCstForecastPlanTypeId
1165: ,xOrigCstForecastVersionId
1166: FROM
1167: pa_budget_versions pbv
1168: , pa_budget_versions orig_pbv
1169: , pa_fin_plan_types_b orig_pfptb
1170: -- , pa_fin_plan_types_tl orig_pfptt
1171: WHERE 1=1
1172: AND pbv.budget_version_id = pCstForecastVersionId
1205: INTO
1206: xCstBudgetPlanTypeId
1207: ,xOrigCstBudgetVersionId
1208: FROM
1209: pa_budget_versions pbv
1210: , pa_budget_versions orig_pbv
1211: , pa_fin_plan_types_b orig_pfptb
1212: --, pa_fin_plan_types_tl orig_pfptt
1213: WHERE 1=1
1206: xCstBudgetPlanTypeId
1207: ,xOrigCstBudgetVersionId
1208: FROM
1209: pa_budget_versions pbv
1210: , pa_budget_versions orig_pbv
1211: , pa_fin_plan_types_b orig_pfptb
1212: --, pa_fin_plan_types_tl orig_pfptt
1213: WHERE 1=1
1214: AND pbv.budget_version_id = pCstBudgetVersionId
1245: INTO
1246: xCstBudget2PlanTypeId
1247: ,xOrigCstBudget2VersionId
1248: FROM
1249: pa_budget_versions pbv
1250: , pa_budget_versions orig_pbv
1251: , pa_fin_plan_types_b orig_pfptb
1252: --, pa_fin_plan_types_tl orig_pfptt
1253: WHERE 1=1
1246: xCstBudget2PlanTypeId
1247: ,xOrigCstBudget2VersionId
1248: FROM
1249: pa_budget_versions pbv
1250: , pa_budget_versions orig_pbv
1251: , pa_fin_plan_types_b orig_pfptb
1252: --, pa_fin_plan_types_tl orig_pfptt
1253: WHERE 1=1
1254: AND pbv.budget_version_id = pCstBudget2VersionId
1286: INTO
1287: xRevForecastPlanTypeId
1288: ,xOrigRevForecastVersionId
1289: FROM
1290: pa_budget_versions pbv
1291: , pa_budget_versions orig_pbv
1292: , pa_fin_plan_types_b orig_pfptb
1293: -- , pa_fin_plan_types_tl orig_pfptt
1294: WHERE 1=1
1287: xRevForecastPlanTypeId
1288: ,xOrigRevForecastVersionId
1289: FROM
1290: pa_budget_versions pbv
1291: , pa_budget_versions orig_pbv
1292: , pa_fin_plan_types_b orig_pfptb
1293: -- , pa_fin_plan_types_tl orig_pfptt
1294: WHERE 1=1
1295: AND pbv.budget_version_id = pRevForecastVersionId
1327: INTO
1328: xRevBudgetPlanTypeId
1329: ,xOrigRevBudgetVersionId
1330: FROM
1331: pa_budget_versions pbv
1332: , pa_budget_versions orig_pbv
1333: , pa_fin_plan_types_b orig_pfptb
1334: --, pa_fin_plan_types_tl orig_pfptt
1335: WHERE 1=1
1328: xRevBudgetPlanTypeId
1329: ,xOrigRevBudgetVersionId
1330: FROM
1331: pa_budget_versions pbv
1332: , pa_budget_versions orig_pbv
1333: , pa_fin_plan_types_b orig_pfptb
1334: --, pa_fin_plan_types_tl orig_pfptt
1335: WHERE 1=1
1336: AND pbv.budget_version_id = pRevBudgetVersionId
1367: INTO
1368: xRevBudget2PlanTypeId
1369: ,xOrigRevBudget2VersionId
1370: FROM
1371: pa_budget_versions pbv
1372: , pa_budget_versions orig_pbv
1373: , pa_fin_plan_types_b orig_pfptb
1374: -- , pa_fin_plan_types_tl orig_pfptt
1375: WHERE 1=1
1368: xRevBudget2PlanTypeId
1369: ,xOrigRevBudget2VersionId
1370: FROM
1371: pa_budget_versions pbv
1372: , pa_budget_versions orig_pbv
1373: , pa_fin_plan_types_b orig_pfptb
1374: -- , pa_fin_plan_types_tl orig_pfptt
1375: WHERE 1=1
1376: AND pbv.budget_version_id = pRevBudget2VersionId