[Home] [Help]
83: pa_budget_lines pb,
84: pa_resource_assignments pa,
85: pa_tasks pt,
86: pa_resource_list_members rm,
87: pa_budget_versions pbv
88: where pbv.budget_version_id = p_budget_version_id
89: and pa.resource_assignment_id = pb.resource_assignment_id
90: and pa.task_id = pt.task_id (+)
91: and pa.budget_version_id = pbv.budget_version_id
131: --cursor to delete all versions prior to the latest baselined balance records if the
132: --budget has been baselined before.
133: cursor c_delbal(p_bdgt_ctrl_type in varchar2, p_bdgt_ver in number) is
134: select a.rowid
135: from pa_bc_balances a, pa_budgetary_control_options pbco, pa_budget_versions pbv
136: where pbv.budget_version_id <> p_bdgt_ver
137: and a.project_id = pbco.project_id
138: and a.project_id = pbv.project_id
139: and a.budget_version_id = pbv.budget_version_id
562: pra_b.resource_list_member_id resource_list_member_id,
563: pra_b.project_id project_id,
564: pra_b.task_id task_id,
565: pbl_b.start_date start_date
566: from pa_budget_versions pbv_b,
567: pa_budgetary_control_options pbco_b,
568: pa_budget_lines pbl_b,
569: pa_resource_assignments pra_b
570: where pbv_b.project_id = p_project_id
587: pra_d.resource_list_member_id resource_list_member_id,
588: pra_d.project_id project_id,
589: pra_d.task_id task_id,
590: pbl_d.start_date start_date
591: from pa_budget_versions pbv_d,
592: pa_budgetary_control_options pbco_d,
593: pa_budget_lines pbl_d,
594: pa_resource_assignments pra_d
595: where pbv_d.project_id = p_project_id
1414: -- R12 Funds Management Uptake
1415: ,bc.burden_method_code
1416: from pa_bc_commitments_all bc,
1417: pa_tasks pt
1418: --,pa_budget_versions pbv,
1419: --pa_budget_types pbt
1420: where bc.project_id = p_project_id
1421: and pt.task_id = bc.task_id;
1422: --and bc.budget_version_id = pbv.budget_version_id