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_VRM_UTILS dependencies on PA_BUDGET_VERSIONS

Line 14: select VERSION_NUMBER from PA_BUDGET_VERSIONS pbv

10: l_diff_amount NUMBER;
11: l_prev_version_number NUMBER;
12:
13: CURSOR get_prev_baselined_version(c_prev_version_number IN NUMBER) IS
14: select VERSION_NUMBER from PA_BUDGET_VERSIONS pbv
15: where PROJECT_ID = p_project_id
16: and pbv.APPROVED_REV_PLAN_TYPE_FLAG ='Y'
17: AND pbv.ci_id IS NULL
18: and pbv.VERSION_NUMBER = c_prev_version_number

Line 22: select REVENUE from PA_BUDGET_VERSIONS pbv

18: and pbv.VERSION_NUMBER = c_prev_version_number
19: and pbv.BUDGET_STATUS_CODE = 'B';
20:
21: CURSOR get_revenue_amount IS
22: select REVENUE from PA_BUDGET_VERSIONS pbv
23: where PROJECT_ID = p_project_id
24: and pbv.APPROVED_REV_PLAN_TYPE_FLAG ='Y'
25: AND pbv.ci_id IS NULL
26: and pbv.VERSION_NUMBER = p_current_version_number

Line 30: select pbv.REVENUE - (select pbv1.REVENUE from PA_BUDGET_VERSIONS pbv1

26: and pbv.VERSION_NUMBER = p_current_version_number
27: and pbv.BUDGET_STATUS_CODE = 'B';
28:
29: CURSOR get_diff_revenue_amount(c_prev_version_number IN NUMBER) IS
30: select pbv.REVENUE - (select pbv1.REVENUE from PA_BUDGET_VERSIONS pbv1
31: where pbv1.PROJECT_ID = pbv.PROJECT_ID and pbv1.APPROVED_REV_PLAN_TYPE_FLAG = 'Y'
32: AND pbv.ci_id IS NULL
33: and pbv1.VERSION_NUMBER = c_prev_version_number and BUDGET_STATUS_CODE = 'B')
34: from PA_BUDGET_VERSIONS pbv where project_id = p_project_id and

Line 34: from PA_BUDGET_VERSIONS pbv where project_id = p_project_id and

30: select pbv.REVENUE - (select pbv1.REVENUE from PA_BUDGET_VERSIONS pbv1
31: where pbv1.PROJECT_ID = pbv.PROJECT_ID and pbv1.APPROVED_REV_PLAN_TYPE_FLAG = 'Y'
32: AND pbv.ci_id IS NULL
33: and pbv1.VERSION_NUMBER = c_prev_version_number and BUDGET_STATUS_CODE = 'B')
34: from PA_BUDGET_VERSIONS pbv where project_id = p_project_id and
35: pbv.APPROVED_REV_PLAN_TYPE_FLAG ='Y' and pbv.BUDGET_STATUS_CODE = 'B'
36: and pbv.VERSION_NUMBER = p_current_version_number;
37:
38: BEGIN

Line 81: select VERSION_NUMBER from PA_BUDGET_VERSIONS pbv

77: l_diff_amount NUMBER;
78: l_prev_version_number NUMBER;
79:
80: CURSOR get_prev_baselined_version(c_prev_version_number IN NUMBER) IS
81: select VERSION_NUMBER from PA_BUDGET_VERSIONS pbv
82: where PROJECT_ID = p_project_id
83: and pbv.APPROVED_COST_PLAN_TYPE_FLAG ='Y'
84: AND pbv.ci_id IS NULL
85: and pbv.VERSION_NUMBER = c_prev_version_number

Line 89: select BURDENED_COST from PA_BUDGET_VERSIONS pbv

85: and pbv.VERSION_NUMBER = c_prev_version_number
86: and pbv.BUDGET_STATUS_CODE = 'B';
87:
88: CURSOR get_cost_amount IS
89: select BURDENED_COST from PA_BUDGET_VERSIONS pbv
90: where PROJECT_ID = p_project_id
91: and pbv.APPROVED_COST_PLAN_TYPE_FLAG ='Y'
92: AND pbv.ci_id IS NULL
93: and pbv.VERSION_NUMBER = p_current_version_number

Line 97: select pbv.BURDENED_COST - (select pbv1.BURDENED_COST from PA_BUDGET_VERSIONS pbv1

93: and pbv.VERSION_NUMBER = p_current_version_number
94: and pbv.BUDGET_STATUS_CODE = 'B';
95:
96: CURSOR get_diff_cost_amount(c_prev_version_number IN NUMBER) IS
97: select pbv.BURDENED_COST - (select pbv1.BURDENED_COST from PA_BUDGET_VERSIONS pbv1
98: where pbv1.PROJECT_ID = pbv.PROJECT_ID and pbv1.APPROVED_COST_PLAN_TYPE_FLAG = 'Y'
99: AND pbv.ci_id IS NULL
100: and pbv1.VERSION_NUMBER = c_prev_version_number and BUDGET_STATUS_CODE = 'B')
101: from PA_BUDGET_VERSIONS pbv where project_id = p_project_id and

Line 101: from PA_BUDGET_VERSIONS pbv where project_id = p_project_id and

97: select pbv.BURDENED_COST - (select pbv1.BURDENED_COST from PA_BUDGET_VERSIONS pbv1
98: where pbv1.PROJECT_ID = pbv.PROJECT_ID and pbv1.APPROVED_COST_PLAN_TYPE_FLAG = 'Y'
99: AND pbv.ci_id IS NULL
100: and pbv1.VERSION_NUMBER = c_prev_version_number and BUDGET_STATUS_CODE = 'B')
101: from PA_BUDGET_VERSIONS pbv where project_id = p_project_id and
102: pbv.APPROVED_COST_PLAN_TYPE_FLAG ='Y' and pbv.BUDGET_STATUS_CODE = 'B'
103: and pbv.VERSION_NUMBER = p_current_version_number;
104:
105: BEGIN

Line 150: select VERSION_NUMBER from PA_BUDGET_VERSIONS pbv

146: l_prev_version_number NUMBER;
147: l_is_initial_baselined_ver CHAR;
148:
149: CURSOR get_prev_cost_version(c_prev_version_number IN NUMBER) IS
150: select VERSION_NUMBER from PA_BUDGET_VERSIONS pbv
151: where PROJECT_ID = p_project_id
152: and pbv.APPROVED_COST_PLAN_TYPE_FLAG ='Y'
153: AND pbv.ci_id IS NULL
154: and pbv.VERSION_NUMBER = c_prev_version_number

Line 158: select VERSION_NUMBER from PA_BUDGET_VERSIONS pbv

154: and pbv.VERSION_NUMBER = c_prev_version_number
155: and pbv.BUDGET_STATUS_CODE = 'B';
156:
157: CURSOR get_prev_rev_version(c_prev_version_number IN NUMBER) IS
158: select VERSION_NUMBER from PA_BUDGET_VERSIONS pbv
159: where PROJECT_ID = p_project_id
160: and pbv.APPROVED_REV_PLAN_TYPE_FLAG ='Y'
161: AND pbv.ci_id IS NULL
162: and pbv.VERSION_NUMBER = c_prev_version_number

Line 214: select BUDGET_VERSION_ID from PA_BUDGET_VERSIONS pbv

210: IS
211: l_initial_baselined_ver NUMBER;
212:
213: CURSOR get_prev_rev_bl_version IS
214: select BUDGET_VERSION_ID from PA_BUDGET_VERSIONS pbv
215: where PROJECT_ID = p_project_id
216: and pbv.APPROVED_REV_PLAN_TYPE_FLAG ='Y'
217: AND pbv.ci_id IS NULL
218: and pbv.VERSION_NUMBER = (select min(VERSION_NUMBER) from PA_BUDGET_VERSIONS where PROJECT_ID = p_project_id

Line 218: and pbv.VERSION_NUMBER = (select min(VERSION_NUMBER) from PA_BUDGET_VERSIONS where PROJECT_ID = p_project_id

214: select BUDGET_VERSION_ID from PA_BUDGET_VERSIONS pbv
215: where PROJECT_ID = p_project_id
216: and pbv.APPROVED_REV_PLAN_TYPE_FLAG ='Y'
217: AND pbv.ci_id IS NULL
218: and pbv.VERSION_NUMBER = (select min(VERSION_NUMBER) from PA_BUDGET_VERSIONS where PROJECT_ID = p_project_id
219: AND APPROVED_REV_PLAN_TYPE_FLAG ='Y' AND ci_id IS NULL AND BUDGET_STATUS_CODE = 'B')
220: and pbv.BUDGET_STATUS_CODE = 'B';
221:
222: BEGIN