APPS.PA_FP_ORG_FCST_UTILS dependencies on PA_FIN_PLAN_VIEW_GLOBAL

Line 907: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()

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
909: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
910: AND pra.resource_assignment_type='PROJECT'
911: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

Line 909: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

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
909: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
910: AND pra.resource_assignment_type='PROJECT'
911: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
912: AND pppd.resource_assignment_id=pra.resource_assignment_id
913: AND pppd.amount_type_code = 'REVENUE'

Line 911: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

907: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
908: AND pra.project_id = pbv.project_id
909: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
910: AND pra.resource_assignment_type='PROJECT'
911: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
912: AND pppd.resource_assignment_id=pra.resource_assignment_id
913: AND pppd.amount_type_code = 'REVENUE'
914: ORDER BY pppd.amount_type_id;
915:

Line 953: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()

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
955: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
956: AND pra.resource_assignment_type='PROJECT'
957: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

Line 955: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

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
955: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
956: AND pra.resource_assignment_type='PROJECT'
957: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
958: AND pppd.resource_assignment_id=pra.resource_assignment_id
959: AND pppd.amount_type_code = 'COST'

Line 957: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

953: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
954: AND pra.project_id = pbv.project_id
955: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
956: AND pra.resource_assignment_type='PROJECT'
957: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
958: AND pppd.resource_assignment_id=pra.resource_assignment_id
959: AND pppd.amount_type_code = 'COST'
960: ORDER BY pppd.amount_type_id;
961:

Line 983: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()

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
985: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
986: AND pra.resource_assignment_type='PROJECT'
987: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

Line 985: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

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
985: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
986: AND pra.resource_assignment_type='PROJECT'
987: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
988: AND pppd.resource_assignment_id=pra.resource_assignment_id
989: AND pppd.amount_type_code = 'HEADCOUNT'

Line 987: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

983: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
984: AND pra.project_id = pbv.project_id
985: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
986: AND pra.resource_assignment_type='PROJECT'
987: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
988: AND pppd.resource_assignment_id=pra.resource_assignment_id
989: AND pppd.amount_type_code = 'HEADCOUNT'
990: ORDER BY pppd.amount_type_id;
991:

Line 1009: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()

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
1011: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1012: AND pra.resource_assignment_type='PROJECT'
1013: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

Line 1011: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

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
1011: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1012: AND pra.resource_assignment_type='PROJECT'
1013: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1014: AND pppd.resource_assignment_id=pra.resource_assignment_id
1015: AND pppd.object_type_code = 'RES_ASSIGNMENT'

Line 1013: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

1009: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1010: AND pra.project_id = pbv.project_id
1011: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1012: AND pra.resource_assignment_type='PROJECT'
1013: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1014: AND pppd.resource_assignment_id=pra.resource_assignment_id
1015: AND pppd.object_type_code = 'RES_ASSIGNMENT'
1016: AND pppd.object_id = pra.resource_assignment_id
1017: AND pppd.amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS';

Line 1036: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()

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
1038: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1039: AND pra.resource_assignment_type='PROJECT'
1040: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

Line 1038: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

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
1038: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1039: AND pra.resource_assignment_type='PROJECT'
1040: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1041: AND pppd.resource_assignment_id=pra.resource_assignment_id
1042: AND pppd.amount_subtype_code = 'BEGIN_HEADCOUNT';

Line 1040: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

1036: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1037: AND pra.project_id = pbv.project_id
1038: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1039: AND pra.resource_assignment_type='PROJECT'
1040: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1041: AND pppd.resource_assignment_id=pra.resource_assignment_id
1042: AND pppd.amount_subtype_code = 'BEGIN_HEADCOUNT';
1043:
1044: return headcount;

Line 1061: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()

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
1063: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1064: AND pra.resource_assignment_type='PROJECT'
1065: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

Line 1063: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

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
1063: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1064: AND pra.resource_assignment_type='PROJECT'
1065: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1066: AND pppd.resource_assignment_id=pra.resource_assignment_id
1067: AND pppd.amount_subtype_code = 'UTILIZATION_PERCENT';

Line 1065: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

1061: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1062: AND pra.project_id = pbv.project_id
1063: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1064: AND pra.resource_assignment_type='PROJECT'
1065: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1066: AND pppd.resource_assignment_id=pra.resource_assignment_id
1067: AND pppd.amount_subtype_code = 'UTILIZATION_PERCENT';
1068:
1069: return util_percent;

Line 1085: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()

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
1087: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1088: AND pra.resource_assignment_type='PROJECT'
1089: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

Line 1087: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

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
1087: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1088: AND pra.resource_assignment_type='PROJECT'
1089: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1090: AND pppd.resource_assignment_id=pra.resource_assignment_id
1091: AND pppd.object_type_code = 'RES_ASSIGNMENT'

Line 1089: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

1085: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1086: AND pra.project_id = pbv.project_id
1087: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1088: AND pra.resource_assignment_type='PROJECT'
1089: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1090: AND pppd.resource_assignment_id=pra.resource_assignment_id
1091: AND pppd.object_type_code = 'RES_ASSIGNMENT'
1092: AND pppd.object_id = pra.resource_assignment_id
1093: AND pppd.amount_subtype_code = 'UTILIZATION_ADJUSTMENTS';

Line 1112: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()

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
1114: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1115: AND pra.resource_assignment_type='PROJECT'
1116: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

Line 1114: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

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
1114: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1115: AND pra.resource_assignment_type='PROJECT'
1116: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1117: AND pppd.resource_assignment_id=pra.resource_assignment_id
1118: AND pppd.amount_type_code = 'UTILIZATION';

Line 1116: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

1112: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1113: AND pra.project_id = pbv.project_id
1114: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1115: AND pra.resource_assignment_type='PROJECT'
1116: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1117: AND pppd.resource_assignment_id=pra.resource_assignment_id
1118: AND pppd.amount_type_code = 'UTILIZATION';
1119:
1120:

Line 1215: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()

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
1217: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1218: AND pra.resource_assignment_type='PROJECT'
1219: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

Line 1217: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

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
1217: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1218: AND pra.resource_assignment_type='PROJECT'
1219: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1220: AND pppd.resource_assignment_id=pra.resource_assignment_id
1221: AND pppd.amount_type_code = 'REVENUE'

Line 1219: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

1215: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1216: AND pra.project_id = pbv.project_id
1217: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1218: AND pra.resource_assignment_type='PROJECT'
1219: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1220: AND pppd.resource_assignment_id=pra.resource_assignment_id
1221: AND pppd.amount_type_code = 'REVENUE'
1222: ORDER BY pppd.amount_type_id;
1223:

Line 1296: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()

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
1298: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1299: AND pra.resource_assignment_type='PROJECT'
1300: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

Line 1298: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

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
1298: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1299: AND pra.resource_assignment_type='PROJECT'
1300: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1301: AND pppd.resource_assignment_id=pra.resource_assignment_id
1302: AND pppd.amount_type_code = 'COST'

Line 1300: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

1296: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1297: AND pra.project_id = pbv.project_id
1298: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1299: AND pra.resource_assignment_type='PROJECT'
1300: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1301: AND pppd.resource_assignment_id=pra.resource_assignment_id
1302: AND pppd.amount_type_code = 'COST'
1303: ORDER BY pppd.amount_type_id;
1304:

Line 1333: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()

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
1335: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1336: AND pra.resource_assignment_type='PROJECT'
1337: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

Line 1335: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

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
1335: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1336: AND pra.resource_assignment_type='PROJECT'
1337: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1338: AND pppd.resource_assignment_id=pra.resource_assignment_id
1339: AND pppd.amount_type_code = 'HEADCOUNT';

Line 1337: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

1333: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1334: AND pra.project_id = pbv.project_id
1335: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1336: AND pra.resource_assignment_type='PROJECT'
1337: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1338: AND pppd.resource_assignment_id=pra.resource_assignment_id
1339: AND pppd.amount_type_code = 'HEADCOUNT';
1340:
1341: return headcount;

Line 1365: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()

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
1367: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1368: AND pra.resource_assignment_type='PROJECT'
1369: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

Line 1367: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

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
1367: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1368: AND pra.resource_assignment_type='PROJECT'
1369: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1370: AND pppd.object_type_code = 'RES_ASSIGNMENT'
1371: AND pppd.object_id = pra.resource_assignment_id

Line 1369: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

1365: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1366: AND pra.project_id = pbv.project_id
1367: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1368: AND pra.resource_assignment_type='PROJECT'
1369: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1370: AND pppd.object_type_code = 'RES_ASSIGNMENT'
1371: AND pppd.object_id = pra.resource_assignment_id
1372: AND pppd.resource_assignment_id=pra.resource_assignment_id
1373: AND pppd.amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS';

Line 1399: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()

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
1401: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1402: AND pra.resource_assignment_type='PROJECT'
1403: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

Line 1401: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

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
1401: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1402: AND pra.resource_assignment_type='PROJECT'
1403: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1404: AND pppd.resource_assignment_id=pra.resource_assignment_id
1405: AND pppd.amount_subtype_code = 'BEGIN_HEADCOUNT'

Line 1403: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

1399: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1400: AND pra.project_id = pbv.project_id
1401: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1402: AND pra.resource_assignment_type='PROJECT'
1403: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1404: AND pppd.resource_assignment_id=pra.resource_assignment_id
1405: AND pppd.amount_subtype_code = 'BEGIN_HEADCOUNT'
1406: ORDER BY pppd.amount_type_id;
1407:

Line 1432: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()

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
1434: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1435: AND pra.resource_assignment_type='PROJECT'
1436: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

Line 1434: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

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
1434: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1435: AND pra.resource_assignment_type='PROJECT'
1436: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1437: AND pppd.resource_assignment_id=pra.resource_assignment_id
1438: AND pppd.amount_subtype_code = 'UTILIZATION_PERCENT'

Line 1436: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

1432: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1433: AND pra.project_id = pbv.project_id
1434: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1435: AND pra.resource_assignment_type='PROJECT'
1436: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1437: AND pppd.resource_assignment_id=pra.resource_assignment_id
1438: AND pppd.amount_subtype_code = 'UTILIZATION_PERCENT'
1439: ORDER BY pppd.amount_type_id;
1440:

Line 1464: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()

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
1466: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1467: AND pra.resource_assignment_type='PROJECT'
1468: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

Line 1466: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

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
1466: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1467: AND pra.resource_assignment_type='PROJECT'
1468: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1469: AND pppd.resource_assignment_id=pra.resource_assignment_id
1470: AND pppd.object_type_code = 'RES_ASSIGNMENT'

Line 1468: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

1464: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1465: AND pra.project_id = pbv.project_id
1466: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1467: AND pra.resource_assignment_type='PROJECT'
1468: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1469: AND pppd.resource_assignment_id=pra.resource_assignment_id
1470: AND pppd.object_type_code = 'RES_ASSIGNMENT'
1471: AND pppd.object_id = pra.resource_assignment_id
1472: AND pppd.amount_subtype_code = 'UTILIZATION_ADJUSTMENTS';

Line 1497: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()

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
1499: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1500: AND pra.resource_assignment_type='PROJECT'
1501: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

Line 1499: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

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
1499: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1500: AND pra.resource_assignment_type='PROJECT'
1501: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1502: AND pppd.resource_assignment_id=pra.resource_assignment_id
1503: AND pppd.amount_type_code = 'UTILIZATION';

Line 1501: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()

1497: WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
1498: AND pra.project_id = pbv.project_id
1499: AND pra.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1500: AND pra.resource_assignment_type='PROJECT'
1501: AND pppd.budget_version_id=pa_fin_plan_view_global.Get_Version_ID()
1502: AND pppd.resource_assignment_id=pra.resource_assignment_id
1503: AND pppd.amount_type_code = 'UTILIZATION';
1504:
1505: return util_percent;