APPS.PA_PLANNING_ELEMENT_UTILS dependencies on PA_RESOURCE_ASGN_CURR

Line 765: -- Bug 6459226: Replacing the queries from pa_resource_asgn_curr

761:
762: -- Bug Fix 3732157
763: -- Moving the code from the body to here as a cursor.
764:
765: -- Bug 6459226: Replacing the queries from pa_resource_asgn_curr
766: -- with pa_budget_lines once again because this cursor is called
767: -- in case budget lines exist and on Edit Budget Line page, we
768: -- have to show the periodic split up of amounts.
769:

Line 973: -- pa_resource_asgn_curr rac,

969: -- */
970: -- DECODE(ra.rate_based_flag, 'Y', rac.txn_etc_burden_cost_rate, TO_NUMBER(NULL))
971: -- FROM pa_resource_assignments ra,
972: -- -- pa_budget_lines bl,
973: -- pa_resource_asgn_curr rac,
974: -- pa_budget_versions bv,
975: -- pa_proj_fp_options po
976: -- WHERE ra.resource_assignment_id = l_resource_assignment_id AND
977: -- -- ra.resource_assignment_id = bl.resource_assignment_id AND

Line 1400: pa_resource_asgn_curr rac,

1396: x_etc_avg_raw_cost_rate,
1397: x_etc_avg_burd_cost_rate
1398: FROM pa_resource_assignments ra,
1399: -- pa_budget_lines bl,
1400: pa_resource_asgn_curr rac,
1401: pa_budget_versions bv,
1402: pa_proj_fp_options po
1403: WHERE ra.resource_assignment_id = l_resource_assignment_id AND
1404: -- ra.resource_assignment_id = bl.resource_assignment_id AND

Line 1757: pa_resource_asgn_curr rac,

1753: NULL, -- x_fcst_margin_pct (TO BE POPULATED)
1754: po.margin_derived_from_code
1755: FROM pa_resource_assignments ra,
1756: -- pa_budget_lines bl,
1757: pa_resource_asgn_curr rac,
1758: pa_budget_versions bv,
1759: pa_proj_fp_options po
1760: WHERE ra.resource_assignment_id = l_resource_assignment_id AND
1761: -- ra.resource_assignment_id = bl.resource_assignment_id AND

Line 2371: pa_resource_asgn_curr rac,

2367: x_fcst_margin_pct,
2368: l_margin_derived_from_code
2369: FROM pa_resource_assignments ra,
2370: -- pa_budget_lines bl,
2371: pa_resource_asgn_curr rac,
2372: pa_budget_versions bv,
2373: pa_proj_fp_options po
2374: where ra.resource_assignment_id = l_resource_assignment_id and
2375: -- ra.resource_assignment_id = bl.resource_assignment_id and