APPS.PA_FP_ORG_FCST_UTILS dependencies on PA_RESOURCE_ASSIGNMENTS

Line 904: FROM pa_resource_assignments pra,

900: )
901: )
902: ) as Total
903: INTO revenue
904: FROM pa_resource_assignments pra,
905: pa_budget_versions pbv,
906: pa_fp_period_values_v pppd
907: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
908: AND pra.project_id = pbv.project_id

Line 950: FROM pa_resource_assignments pra,

946: )
947: )
948: ) as Total
949: INTO cost
950: FROM pa_resource_assignments pra,
951: pa_budget_versions pbv,
952: pa_fp_period_values_v pppd
953: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
954: AND pra.project_id = pbv.project_id

Line 980: FROM pa_resource_assignments pra,

976: sum(nvl(pppd.period_amount4,0))+
977: sum(nvl(pppd.period_amount5,0))+
978: sum(nvl(pppd.period_amount6,0)))/6,0)
979: INTO headcount
980: FROM pa_resource_assignments pra,
981: pa_budget_versions pbv,
982: pa_fp_period_values_v pppd
983: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
984: AND pra.project_id = pbv.project_id

Line 1006: FROM pa_resource_assignments pra,

1002: nvl(pppd.period_amount4,0)+
1003: nvl(pppd.period_amount5,0)+
1004: nvl(pppd.period_amount6,0))/6,0)
1005: INTO headcount
1006: FROM pa_resource_assignments pra,
1007: pa_budget_versions pbv,
1008: pa_fp_period_values_v pppd
1009: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1010: AND pra.project_id = pbv.project_id

Line 1033: FROM pa_resource_assignments pra,

1029: nvl(pppd.period_amount4,0)+
1030: nvl(pppd.period_amount5,0)+
1031: nvl(pppd.period_amount6,0))/6,0)
1032: INTO headcount
1033: FROM pa_resource_assignments pra,
1034: pa_budget_versions pbv,
1035: pa_fp_period_values_v pppd
1036: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1037: AND pra.project_id = pbv.project_id

Line 1058: FROM pa_resource_assignments pra,

1054: nvl(pppd.period_amount4,0)+
1055: nvl(pppd.period_amount5,0)+
1056: nvl(pppd.period_amount6,0))/6
1057: INTO util_percent
1058: FROM pa_resource_assignments pra,
1059: pa_budget_versions pbv,
1060: pa_fp_period_values_v pppd
1061: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1062: AND pra.project_id = pbv.project_id

Line 1082: FROM pa_resource_assignments pra,

1078: nvl(pppd.period_amount4,0)+
1079: nvl(pppd.period_amount5,0)+
1080: nvl(pppd.period_amount6,0))/6
1081: INTO util_percent
1082: FROM pa_resource_assignments pra,
1083: pa_budget_versions pbv,
1084: pa_fp_period_values_v pppd
1085: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1086: AND pra.project_id = pbv.project_id

Line 1109: FROM pa_resource_assignments pra,

1105: sum(nvl(pppd.period_amount4,0))+
1106: sum(nvl(pppd.period_amount5,0))+
1107: sum(nvl(pppd.period_amount6,0)))/6
1108: INTO util_percent
1109: FROM pa_resource_assignments pra,
1110: pa_budget_versions pbv,
1111: pa_fp_period_values_v pppd
1112: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1113: AND pra.project_id = pbv.project_id

Line 1212: FROM pa_resource_assignments pra,

1208: )
1209: )
1210: )
1211: INTO revenue
1212: FROM pa_resource_assignments pra,
1213: pa_budget_versions pbv,
1214: pa_fp_period_values_v pppd
1215: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1216: AND pra.project_id = pbv.project_id

Line 1293: FROM pa_resource_assignments pra,

1289: )
1290: )
1291: )
1292: INTO cost
1293: FROM pa_resource_assignments pra,
1294: pa_budget_versions pbv,
1295: pa_fp_period_values_v pppd
1296: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1297: AND pra.project_id = pbv.project_id

Line 1330: FROM pa_resource_assignments pra,

1326: sum(nvl(pppd.period_amount11,0))+
1327: sum(nvl(pppd.period_amount12,0))+
1328: sum(nvl(pppd.period_amount13,0)))/13,0)
1329: INTO headcount
1330: FROM pa_resource_assignments pra,
1331: pa_budget_versions pbv,
1332: pa_fp_period_values_v pppd
1333: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1334: AND pra.project_id = pbv.project_id

Line 1362: FROM pa_resource_assignments pra,

1358: nvl(pppd.period_amount11,0)+
1359: nvl(pppd.period_amount12,0)+
1360: nvl(pppd.period_amount13,0))/13,0)
1361: INTO headcount
1362: FROM pa_resource_assignments pra,
1363: pa_budget_versions pbv,
1364: pa_fp_period_values_v pppd
1365: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1366: AND pra.project_id = pbv.project_id

Line 1396: FROM pa_resource_assignments pra,

1392: nvl(pppd.period_amount11,0)+
1393: nvl(pppd.period_amount12,0)+
1394: nvl(pppd.period_amount13,0))/13,0)
1395: INTO headcount
1396: FROM pa_resource_assignments pra,
1397: pa_budget_versions pbv,
1398: pa_fp_period_values_v pppd
1399: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1400: AND pra.project_id = pbv.project_id

Line 1429: FROM pa_resource_assignments pra,

1425: nvl(pppd.period_amount11,0)+
1426: nvl(pppd.period_amount12,0)+
1427: nvl(pppd.period_amount13,0)) /13
1428: INTO util_percent
1429: FROM pa_resource_assignments pra,
1430: pa_budget_versions pbv,
1431: pa_fp_period_values_v pppd
1432: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1433: AND pra.project_id = pbv.project_id

Line 1461: FROM pa_resource_assignments pra,

1457: nvl(pppd.period_amount11,0)+
1458: nvl(pppd.period_amount12,0)+
1459: nvl(pppd.period_amount13,0)) /13
1460: INTO util_percent
1461: FROM pa_resource_assignments pra,
1462: pa_budget_versions pbv,
1463: pa_fp_period_values_v pppd
1464: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1465: AND pra.project_id = pbv.project_id

Line 1494: FROM pa_resource_assignments pra,

1490: sum(nvl(pppd.period_amount11,0))+
1491: sum(nvl(pppd.period_amount12,0))+
1492: sum(nvl(pppd.period_amount13,0))) /13
1493: INTO util_percent
1494: FROM pa_resource_assignments pra,
1495: pa_budget_versions pbv,
1496: pa_fp_period_values_v pppd
1497: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1498: AND pra.project_id = pbv.project_id