DBA Data[Home] [Help]

APPS.PJI_REP_MEASURE_UTIL dependencies on PA_FIN_PLAN_TYPES_B

Line 1162: , pa_fin_plan_types_b orig_pfptb

1158: ,xOrigCstForecastVersionId
1159: FROM
1160: pa_budget_versions pbv
1161: , pa_budget_versions orig_pbv
1162: , pa_fin_plan_types_b orig_pfptb
1163: -- , pa_fin_plan_types_tl orig_pfptt
1164: WHERE 1=1
1165: AND pbv.budget_version_id = pCstForecastVersionId
1166: AND pbv.fin_plan_type_id = orig_pbv.fin_plan_type_id

Line 1204: , pa_fin_plan_types_b orig_pfptb

1200: ,xOrigCstBudgetVersionId
1201: FROM
1202: pa_budget_versions pbv
1203: , pa_budget_versions orig_pbv
1204: , pa_fin_plan_types_b orig_pfptb
1205: --, pa_fin_plan_types_tl orig_pfptt
1206: WHERE 1=1
1207: AND pbv.budget_version_id = pCstBudgetVersionId
1208: AND pbv.fin_plan_type_id = orig_pbv.fin_plan_type_id

Line 1244: , pa_fin_plan_types_b orig_pfptb

1240: ,xOrigCstBudget2VersionId
1241: FROM
1242: pa_budget_versions pbv
1243: , pa_budget_versions orig_pbv
1244: , pa_fin_plan_types_b orig_pfptb
1245: --, pa_fin_plan_types_tl orig_pfptt
1246: WHERE 1=1
1247: AND pbv.budget_version_id = pCstBudget2VersionId
1248: AND pbv.fin_plan_type_id = orig_pbv.fin_plan_type_id

Line 1285: , pa_fin_plan_types_b orig_pfptb

1281: ,xOrigRevForecastVersionId
1282: FROM
1283: pa_budget_versions pbv
1284: , pa_budget_versions orig_pbv
1285: , pa_fin_plan_types_b orig_pfptb
1286: -- , pa_fin_plan_types_tl orig_pfptt
1287: WHERE 1=1
1288: AND pbv.budget_version_id = pRevForecastVersionId
1289: AND pbv.fin_plan_type_id = orig_pbv.fin_plan_type_id

Line 1326: , pa_fin_plan_types_b orig_pfptb

1322: ,xOrigRevBudgetVersionId
1323: FROM
1324: pa_budget_versions pbv
1325: , pa_budget_versions orig_pbv
1326: , pa_fin_plan_types_b orig_pfptb
1327: --, pa_fin_plan_types_tl orig_pfptt
1328: WHERE 1=1
1329: AND pbv.budget_version_id = pRevBudgetVersionId
1330: AND pbv.fin_plan_type_id = orig_pbv.fin_plan_type_id

Line 1366: , pa_fin_plan_types_b orig_pfptb

1362: ,xOrigRevBudget2VersionId
1363: FROM
1364: pa_budget_versions pbv
1365: , pa_budget_versions orig_pbv
1366: , pa_fin_plan_types_b orig_pfptb
1367: -- , pa_fin_plan_types_tl orig_pfptt
1368: WHERE 1=1
1369: AND pbv.budget_version_id = pRevBudget2VersionId
1370: AND pbv.fin_plan_type_id = orig_pbv.fin_plan_type_id