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_CONTROL_ITEMS_UTILS dependencies on PA_PROJECT_STATUSES

Line 4763: ,pa_project_statuses pcs

4759: ,PBV.TOTAL_PROJECT_RAW_COST AS RAW_COST
4760: ,PBV.TOTAL_PROJECT_BURDENED_COST AS BURDENED_COST
4761: FROM pa_budget_versions pbv
4762: ,pa_control_items pci
4763: ,pa_project_statuses pcs
4764: ,pa_ci_types_vl pct
4765: WHERE PBV.CI_ID = PCI.CI_ID
4766: AND PBV.PROJECT_ID = PCI.PROJECT_ID
4767: AND PCI.STATUS_CODE = PCS.PROJECT_STATUS_CODE

Line 4827: ,pa_project_statuses pcs

4823: ,PBV.TOTAL_PROJECT_REVENUE AS REVENUE
4824: ,nvl(PBV.REV_PARTIALLY_IMPL_FLAG,'N') AS REV_PARTIALLY_IMPL_FLAG
4825: FROM pa_budget_versions pbv
4826: ,pa_control_items pci
4827: ,pa_project_statuses pcs
4828: ,pa_ci_types_vl pct
4829: WHERE PBV.CI_ID = PCI.CI_ID
4830: AND PBV.PROJECT_ID = PCI.PROJECT_ID
4831: AND PCI.STATUS_CODE = PCS.PROJECT_STATUS_CODE

Line 9264: pa_project_statuses pps

9260: --Get the CI status code
9261: SELECT pps.project_system_status_code
9262: INTO x_ci_status_code
9263: FROM pa_control_items pci,
9264: pa_project_statuses pps
9265: WHERE pci.ci_id=p_ci_id
9266: AND pps.project_status_code=pci.status_code;
9267:
9268: --Derive the value for x_impact_in_mc_flag. This should be 'Y' if either COST or REVENUE impact is