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_CLIENT_EXTN_STATUS dependencies on PA_STATUS

Line 172: FROM pa_status_proj_v

168: , p_base_burdened_cost_itd
169: , p_base_revenue_tot
170: , p_revenue_itd
171: , p_revenue_ptd
172: FROM pa_status_proj_v
173: WHERE project_id = x_project_id;
174:
175: ELSIF (x_status_view = 'TASKS') THEN
176:

Line 195: FROM pa_status_task_v

191: , p_base_burdened_cost_itd
192: , p_base_revenue_tot
193: , p_revenue_itd
194: , p_revenue_ptd
195: FROM pa_status_task_v
196: WHERE project_id = x_project_id
197: AND task_id = x_task_id;
198:
199: ELSIF (x_status_view = 'RESOURCES') THEN

Line 218: FROM pa_status_rsrc_v

214: , p_cmt_burdened_cost_ptd
215: , p_base_burdened_cost_itd
216: , p_base_revenue_tot
217: , p_revenue_itd
218: FROM pa_status_rsrc_v
219: WHERE project_id = x_project_id
220: AND task_id is null
221: AND resource_list_member_id = x_resource_list_member_id;
222:

Line 240: FROM pa_status_rsrc_v

236: , p_cmt_burdened_cost_ptd
237: , p_base_burdened_cost_itd
238: , p_base_revenue_tot
239: , p_revenue_itd
240: FROM pa_status_rsrc_v
241: WHERE project_id = x_project_id
242: AND task_id = x_task_id
243: AND resource_list_member_id = x_resource_list_member_id;
244: END IF;

Line 276: x_derived_col_26 := (ROUND(p_base_burdened_cost_tot - p_cmt_burdened_cost_ptd - p_burdened_cost_itd))/(PA_STATUS.Get_Factor);

272: x_derived_col_25 := ROUND((p_actuals_labor_hours_itd/ p_base_cost_labor_hours_tot) * 100);
273: END IF;
274:
275: -- Estimate To Complete
276: x_derived_col_26 := (ROUND(p_base_burdened_cost_tot - p_cmt_burdened_cost_ptd - p_burdened_cost_itd))/(PA_STATUS.Get_Factor);
277:
278: -- Total Cost ITD
279: x_derived_col_27 := (ROUND(p_burdened_cost_itd + p_cmt_burdened_cost_ptd))/(PA_STATUS.Get_Factor);
280:

Line 279: x_derived_col_27 := (ROUND(p_burdened_cost_itd + p_cmt_burdened_cost_ptd))/(PA_STATUS.Get_Factor);

275: -- Estimate To Complete
276: x_derived_col_26 := (ROUND(p_base_burdened_cost_tot - p_cmt_burdened_cost_ptd - p_burdened_cost_itd))/(PA_STATUS.Get_Factor);
277:
278: -- Total Cost ITD
279: x_derived_col_27 := (ROUND(p_burdened_cost_itd + p_cmt_burdened_cost_ptd))/(PA_STATUS.Get_Factor);
280:
281: -- Over Budget
282: IF ((p_burdened_cost_itd + p_cmt_burdened_cost_ptd ) > (p_base_burdened_cost_itd * 1.1)) THEN
283: x_derived_col_3 := '*';

Line 293: x_derived_col_28 := (ROUND(p_base_revenue_tot - p_base_burdened_cost_tot)) /(PA_STATUS.Get_Factor);

289: --
290: IF (x_pa_install = 'BILLING') THEN
291:
292: -- Budgeted/Plan Margin, ITD
293: x_derived_col_28 := (ROUND(p_base_revenue_tot - p_base_burdened_cost_tot)) /(PA_STATUS.Get_Factor);
294:
295: -- Actual Margin, ITD
296: x_derived_col_29 := (ROUND(p_revenue_itd - p_burdened_cost_itd)) /(PA_STATUS.Get_Factor);
297:

Line 296: x_derived_col_29 := (ROUND(p_revenue_itd - p_burdened_cost_itd)) /(PA_STATUS.Get_Factor);

292: -- Budgeted/Plan Margin, ITD
293: x_derived_col_28 := (ROUND(p_base_revenue_tot - p_base_burdened_cost_tot)) /(PA_STATUS.Get_Factor);
294:
295: -- Actual Margin, ITD
296: x_derived_col_29 := (ROUND(p_revenue_itd - p_burdened_cost_itd)) /(PA_STATUS.Get_Factor);
297:
298: ELSE
299:
300: x_derived_col_28 := NULL;

Line 325: x_derived_col_24 := (ROUND(p_base_burdened_cost_tot - p_cmt_burdened_cost_ptd - p_burdened_cost_itd))/(PA_STATUS.Get_Factor);

321: x_derived_col_23 := ROUND((p_actuals_labor_hours_itd/ p_base_cost_labor_hours_tot) * 100);
322: END IF;
323:
324: -- Estimate To Complete
325: x_derived_col_24 := (ROUND(p_base_burdened_cost_tot - p_cmt_burdened_cost_ptd - p_burdened_cost_itd))/(PA_STATUS.Get_Factor);
326:
327: -- Total Cost ITD
328: x_derived_col_25 := (ROUND(p_burdened_cost_itd + p_cmt_burdened_cost_ptd))/(PA_STATUS.Get_Factor);
329:

Line 328: x_derived_col_25 := (ROUND(p_burdened_cost_itd + p_cmt_burdened_cost_ptd))/(PA_STATUS.Get_Factor);

324: -- Estimate To Complete
325: x_derived_col_24 := (ROUND(p_base_burdened_cost_tot - p_cmt_burdened_cost_ptd - p_burdened_cost_itd))/(PA_STATUS.Get_Factor);
326:
327: -- Total Cost ITD
328: x_derived_col_25 := (ROUND(p_burdened_cost_itd + p_cmt_burdened_cost_ptd))/(PA_STATUS.Get_Factor);
329:
330: -- Over Budget
331: IF ((p_burdened_cost_itd + p_cmt_burdened_cost_ptd ) > (p_base_burdened_cost_itd * 1.1)) THEN
332: x_derived_col_3 := '*';

Line 342: x_derived_col_26 := (ROUND(p_base_revenue_tot - p_base_burdened_cost_tot)) /(PA_STATUS.Get_Factor);

338: --
339: IF (x_pa_install = 'BILLING') THEN
340:
341: -- Budgeted/Plan Margin, ITD
342: x_derived_col_26 := (ROUND(p_base_revenue_tot - p_base_burdened_cost_tot)) /(PA_STATUS.Get_Factor);
343:
344: -- Actual Margin, ITD
345: x_derived_col_27 := (ROUND(p_revenue_itd - p_burdened_cost_itd)) /(PA_STATUS.Get_Factor);
346:

Line 345: x_derived_col_27 := (ROUND(p_revenue_itd - p_burdened_cost_itd)) /(PA_STATUS.Get_Factor);

341: -- Budgeted/Plan Margin, ITD
342: x_derived_col_26 := (ROUND(p_base_revenue_tot - p_base_burdened_cost_tot)) /(PA_STATUS.Get_Factor);
343:
344: -- Actual Margin, ITD
345: x_derived_col_27 := (ROUND(p_revenue_itd - p_burdened_cost_itd)) /(PA_STATUS.Get_Factor);
346:
347: ELSE
348:
349: x_derived_col_26 := NULL;