APPS.PA_FP_MULTI_CURRENCY_PKG dependencies on PA_RESOURCE_ASSIGNMENTS

Line 180: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

176:
177: l_project_name pa_projects_all.name%TYPE;
178: l_task_name pa_proj_elements.name%TYPE;
179: l_resource_name pa_resource_list_members.alias%TYPE;
180: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
181:
182: l_allow_user_rate_type VARCHAR2(1);
183: l_call_closest_flag varchar2(1) := 'F'; -- Added for Bug#5395732
184:

Line 195: ,pa_resource_assignments pra

191: ,prl.alias resource_name
192: FROM pa_projects_all ppa
193: ,pa_proj_elements pt
194: ,pa_resource_list_members prl
195: ,pa_resource_assignments pra
196: WHERE pra.resource_assignment_id = p_resource_assignment_id
197: AND ppa.project_id = pra.project_id
198: AND pt.proj_element_id(+) = pra.task_id
199: AND prl.resource_list_member_id(+) = pra.resource_list_member_id;

Line 1941: from pa_resource_assignments b

1937: --,pa_fp_txn_currencies c
1938: where a.budget_version_id = p_budget_version_id
1939: and bv.budget_version_id = a.budget_version_id
1940: and EXISTS (select null
1941: from pa_resource_assignments b
1942: where b.resource_assignment_id = a.resource_assignment_id
1943: and b.budget_version_id = a.budget_version_id
1944: )
1945: /** Perf Bug: 3683132 a.budget_version_id = c.fin_plan_version_id (+)

Line 1948: from pa_resource_assignments b

1944: )
1945: /** Perf Bug: 3683132 a.budget_version_id = c.fin_plan_version_id (+)
1946: and a.txn_currency_code = c.txn_currency_code (+)
1947: and a.resource_assignment_id in (select b.resource_assignment_id
1948: from pa_resource_assignments b
1949: where b.resource_assignment_id =
1950: a.resource_assignment_id
1951: and b.budget_version_id =
1952: p_budget_version_id)

Line 2754: pa_resource_assignments pra

2750: pbl.raw_cost, pbl.burdened_cost, pbl.revenue,pbl.projfunc_currency_code,
2751: pbl.project_raw_cost, pbl.project_burdened_cost, pbl.project_revenue, pbl.project_currency_code,
2752: pbl.txn_raw_cost, pbl.txn_burdened_cost, pbl.txn_revenue, pbl.txn_currency_code, pra.rate_based_flag
2753: FROM pa_budget_lines pbl,
2754: pa_resource_assignments pra
2755: WHERE pbl.budget_version_id = p_budget_version_id
2756: AND pra.resource_assignment_id=pbl.resource_assignment_id
2757: ORDER BY pbl.txn_currency_code;
2758:

Line 2769: pa_resource_assignments pra

2765: pbl.raw_cost, pbl.burdened_cost, pbl.revenue,pbl.projfunc_currency_code,
2766: pbl.project_raw_cost, pbl.project_burdened_cost, pbl.project_revenue, pbl.project_currency_code,
2767: pbl.txn_raw_cost, pbl.txn_burdened_cost, pbl.txn_revenue, pbl.txn_currency_code, pra.rate_based_flag
2768: FROM pa_budget_lines pbl,
2769: pa_resource_assignments pra
2770: WHERE pbl.budget_version_id = p_budget_version_id
2771: AND pra.resource_assignment_id=pbl.resource_assignment_id
2772: AND budget_line_id > p_bls_inserted_after_id
2773: ORDER BY pbl.txn_currency_code;