eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_ORG_FCST_UTILS dependencies on PA_FP_PERIOD_VALUES_V

Line 906: pa_fp_period_values_v pppd

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

Line 952: pa_fp_period_values_v pppd

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

Line 982: pa_fp_period_values_v pppd

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

Line 1008: pa_fp_period_values_v pppd

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

Line 1035: pa_fp_period_values_v pppd

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

Line 1060: pa_fp_period_values_v pppd

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

Line 1084: pa_fp_period_values_v pppd

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

Line 1111: pa_fp_period_values_v pppd

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

Line 1214: pa_fp_period_values_v pppd

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

Line 1295: pa_fp_period_values_v pppd

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

Line 1332: pa_fp_period_values_v pppd

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

Line 1364: pa_fp_period_values_v pppd

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

Line 1398: pa_fp_period_values_v pppd

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

Line 1431: pa_fp_period_values_v pppd

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

Line 1463: pa_fp_period_values_v pppd

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

Line 1496: pa_fp_period_values_v pppd

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