DBA Data[Home] [Help]

APPS.PA_BGT_BASELINE_PKG dependencies on PA_BUDGETARY_CONTROL_OPTIONS

Line 135: from pa_bc_balances a, pa_budgetary_control_options pbco, pa_budget_versions pbv

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

Line 567: pa_budgetary_control_options pbco_b,

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
571: and pbv_b.budget_status_code = 'B'

Line 592: pa_budgetary_control_options pbco_d,

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
596: and pbv_d.budget_status_code in ('W','S')