APPS.PA_COST1 dependencies on PA_BUDGET_LINES

Line 2366: ,pa_budget_lines bl

2362: from pa_budget_versions bv
2363: ,pa_proj_fp_options fpo
2364: ,pa_projects_all pp
2365: ,pa_fp_txn_currencies cur
2366: ,pa_budget_lines bl
2367: where bv.project_id = pp.project_id
2368: and fpo.project_id = pp.project_id
2369: and nvl(fpo.fin_plan_type_id,0) = nvl(bv.fin_plan_type_id,0)
2370: and fpo.fin_plan_version_id = bv.budget_version_id

Line 2381: (select null from pa_budget_lines bl1

2377: and trunc(p_txn_date) between trunc(bl.start_date) and nvl(bl.end_date,p_txn_date)
2378: and bl.txn_currency_code = p_txn_curr_code
2379: ) OR
2380: (NOT EXISTS
2381: (select null from pa_budget_lines bl1
2382: where bl1.budget_version_id = bv.budget_version_id
2383: and bl1.resource_assignment_id = lv_resource_assignment_id
2384: and trunc(p_txn_date) between trunc(bl1.start_date) and nvl(bl1.end_date,p_txn_date)
2385: and bl.txn_currency_code = p_txn_curr_code

Line 2432: FROM pa_budget_lines bl

2428: SELECT bl.budget_version_id
2429: ,bl.resource_assignment_id
2430: INTO l_budget_version_id
2431: ,l_resource_assignment_id
2432: FROM pa_budget_lines bl
2433: WHERE bl.budget_line_id = p_budget_line_id;
2434: End If;
2435: Exception
2436: When No_data_found Then