APPS.PA_FP_MAP_BV_PUB dependencies on PA_RESOURCE_ASSIGNMENTS

Line 39: FROM pa_resource_assignments ra,

35: sum(bl.project_revenue),
36: sum(bl.raw_cost),
37: sum(bl.burdened_cost),
38: sum(bl.revenue)
39: FROM pa_resource_assignments ra,
40: pa_budget_lines bl,
41: pa_fp_calc_amt_tmp3 t3
42: WHERE ra.resource_assignment_id = bl.resource_assignment_id
43: AND ra.resource_assignment_id = t3.res_asg_id

Line 262: FROM pa_resource_assignments ra

258: ra.resource_assignment_id
259: BULK COLLECT
260: INTO l_tsk_id_tab,
261: l_resrc_assgn_id
262: FROM pa_resource_assignments ra
263: WHERE ra.budget_version_id = p_etc_fp_cols_rec.
264: x_budget_version_id;
265:
266: FORALL m in 1..l_tsk_id_tab.count

Line 369: FROM pa_resource_assignments ra,

365: sum(bl.project_revenue),
366: sum(bl.raw_cost),
367: sum(bl.burdened_cost),
368: sum(bl.revenue)
369: FROM pa_resource_assignments ra,
370: pa_budget_lines bl
371: WHERE ra.resource_assignment_id = bl.resource_assignment_id
372: AND ra.budget_version_id = p_source_bv_id
373: and bl.cost_rejection_code is null

Line 428: FROM pa_resource_assignments ra,

424: sum(bl.project_revenue),
425: sum(bl.raw_cost),
426: sum(bl.burdened_cost),
427: sum(bl.revenue)
428: FROM pa_resource_assignments ra,
429: pa_budget_lines bl
430: WHERE ra.resource_assignment_id = bl.resource_assignment_id
431: AND ra.budget_version_id = p_source_bv_id
432: and bl.cost_rejection_code is null

Line 569: UPDATE pa_resource_assignments

565: /* dbms_output.put_line('Status of map_rlmi_rbs api: '
566: ||X_RETURN_STATUS); */
567:
568: FORALL i IN 1..l_txn_src_id_tab.count
569: UPDATE pa_resource_assignments
570: SET rbs_element_id = l_rbs_element_id_tab(i),
571: txn_accum_header_id = l_txn_accum_header_id_tab(i)
572: WHERE resource_assignment_id = l_txn_src_id_tab(i);
573: