APPS.PA_BUDGET_FUND_PKG dependencies on PA_BUDGET_LINES

Line 746: --Cursor to select BGT budget balances from pa_budget_lines,etc.

742: p_bdgt_intg_flag in varchar2,
743: x_return_status out NOCOPY varchar2,
744: x_error_message_code out NOCOPY varchar2) is
745:
746: --Cursor to select BGT budget balances from pa_budget_lines,etc.
747: cursor c_bdgt_bal is
748: select pa.task_id,
749: pt.top_task_id,
750: pa.resource_list_member_id,

Line 757: pa_budget_lines pb,

753: pb.END_DATE,
754: rm.PARENT_MEMBER_ID,
755: pb.burdened_cost
756: from
757: pa_budget_lines pb,
758: pa_resource_assignments pa,
759: pa_tasks pt,
760: pa_resource_list_members rm,
761: pa_budget_versions pbv

Line 907: l_total_cc_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;

903: l_cbc_not_supported EXCEPTION;
904:
905: l_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
906: l_cc_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
907: l_total_cc_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;
908: l_total_gl_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;
909: l_rebaseline_flag VARCHAR2(1);
910: l_cc_budget_type_code VARCHAR2(30) ;
911: l_cc_encumbrance_type_id NUMBER ;

Line 908: l_total_gl_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;

904:
905: l_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
906: l_cc_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
907: l_total_cc_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;
908: l_total_gl_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;
909: l_rebaseline_flag VARCHAR2(1);
910: l_cc_budget_type_code VARCHAR2(30) ;
911: l_cc_encumbrance_type_id NUMBER ;
912:

Line 946: FROM PA_BUDGET_LINES PBL,

942: CURSOR c_budget_sum_amt(c_budget_version_id NUMBER) IS
943: SELECT sum(decode(nvl(PBL.burdened_cost,0),
944: 0,nvl(PBL.raw_cost,0),
945: PBL.burdened_cost))
946: FROM PA_BUDGET_LINES PBL,
947: PA_BUDGET_VERSIONS PBV,
948: PA_RESOURCE_ASSIGNMENTS PRA
949: WHERE PBV.project_id = p_project_id
950: AND PBV.budget_version_id = PRA.budget_version_id

Line 978: from pa_budget_lines

974:
975: --Bug 6524116
976: cursor get_rejected_event_id is
977: select bc_event_id, g_org_id
978: from pa_budget_lines
979: where budget_version_id = P_Budget_version_id
980: and bc_event_id is not null
981: union
982: select bc_rev_event_id, g_org_id

Line 983: from pa_budget_lines

979: where budget_version_id = P_Budget_version_id
980: and bc_event_id is not null
981: union
982: select bc_rev_event_id, g_org_id
983: from pa_budget_lines
984: where budget_version_id = P_prev_budget_version_id
985: and bc_rev_event_id is not null;
986:
987: BEGIN

Line 1858: from pa_budget_lines bl

1854: close get_rejected_event_id;
1855: else
1856: select bc_event_id, g_org_id
1857: bulk collect into rejected_event_id_tab, ledger_id_tab
1858: from pa_budget_lines bl
1859: where budget_version_id = P_Budget_version_id
1860: and bc_event_id is not null;
1861: end if;
1862: /*PSA_FUNDS_CHECKER_PKG.sync_xla_errors(p_failed_ldgr_array => ledger_id_tab,