APPS.PA_COST1 dependencies on PA_BUDGET_LINES

Line 2678: ,pa_budget_lines bl

2674: from pa_budget_versions bv
2675: ,pa_proj_fp_options fpo
2676: ,pa_projects_all pp
2677: ,pa_fp_txn_currencies cur
2678: ,pa_budget_lines bl
2679: where bv.project_id = pp.project_id
2680: and fpo.project_id = pp.project_id
2681: and nvl(fpo.fin_plan_type_id,0) = nvl(bv.fin_plan_type_id,0)
2682: and fpo.fin_plan_version_id = bv.budget_version_id

Line 2693: (select null from pa_budget_lines bl1

2689: and trunc(p_txn_date) between trunc(bl.start_date) and nvl(bl.end_date,p_txn_date)
2690: and bl.txn_currency_code = p_txn_curr_code
2691: ) OR
2692: (NOT EXISTS
2693: (select null from pa_budget_lines bl1
2694: where bl1.budget_version_id = bv.budget_version_id
2695: and bl1.resource_assignment_id = lv_resource_assignment_id
2696: and trunc(p_txn_date) between trunc(bl1.start_date) and nvl(bl1.end_date,p_txn_date)
2697: and bl.txn_currency_code = p_txn_curr_code

Line 2744: FROM pa_budget_lines bl

2740: SELECT bl.budget_version_id
2741: ,bl.resource_assignment_id
2742: INTO l_budget_version_id
2743: ,l_resource_assignment_id
2744: FROM pa_budget_lines bl
2745: WHERE bl.budget_line_id = p_budget_line_id;
2746: End If;
2747: Exception
2748: When No_data_found Then