APPS.PA_FP_MAP_BV_PUB dependencies on PA_BUDGET_LINES

Line 19: CURSOR txn_sum_csr(c_project_currency_code PA_BUDGET_LINES.PROJECT_CURRENCY_CODE%TYPE,

15: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
16:
17: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_map_bv_pub.gen_map_bv_to_target_rl';
18:
19: CURSOR txn_sum_csr(c_project_currency_code PA_BUDGET_LINES.PROJECT_CURRENCY_CODE%TYPE,
20: c_multi_curr_flag PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE)IS
21: SELECT /*+ INDEX(t3,PA_FP_CALC_AMT_TMP3_N2)*/
22: t3.res_list_member_id,
23: ra.task_id,

Line 40: pa_budget_lines bl,

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
44: AND ra.budget_version_id = p_source_bv_id

Line 370: pa_budget_lines bl

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
374: and bl.revenue_rejection_code is null

Line 429: pa_budget_lines bl

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
433: and bl.revenue_rejection_code is null