APPS.PJI_PA_DEL_MAIN dependencies on PA_BUDGET_VERSIONS

Line 178: from pa_projects_all pa, pa_budget_versions fp

174: and wp.conc_request_id = FND_GLOBAL.CONC_REQUEST_ID; /* Modified for bug 9049425 */
175:
176: cursor proj_fp(p_from_proj varchar2,p_to_proj varchar2) is
177: select pa.segment1 num,fp.version_name fp_name
178: from pa_projects_all pa, pa_budget_versions fp
179: where pa.segment1 between p_from_proj and p_to_proj
180: and pa.project_id = fp.project_id
181: and fp.purged_flag = 'Y'
182: and fp.fin_plan_type_id <> 10

Line 346: from pa_budget_versions

342: begin
343:
344: select budget_version_id
345: into l_budget_version_id
346: from pa_budget_versions
347: where project_id = l_project_id
348: and fin_plan_type_id = 10
349: and project_structure_version_id = rec1.element_version_id;
350:

Line 471: FROM pa_budget_versions

467: l_plan_type_id number(15);
468: -- Fetching the Baselined Versions eligible for deletion
469: CURSOR c1 IS
470: SELECT budget_version_id,record_version_number
471: FROM pa_budget_versions
472: WHERE project_id = l_project_id
473: AND fin_plan_type_id <> 10
474: AND budget_status_code = 'B'
475: AND current_flag <> 'Y'

Line 481: FROM pa_budget_versions

477: and nvl(purged_flag,'N') <> 'Y';
478:
479: CURSOR c2 IS
480: SELECT budget_version_id,record_version_number
481: FROM pa_budget_versions
482: WHERE project_id = l_project_id
483: AND fin_plan_type_id = l_plan_type_id
484: AND budget_status_code = 'B'
485: AND current_flag <> 'Y'