APPS.PA_BUDGET_FUND_PKG dependencies on PA_BUDGET_LINES

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

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

Line 761: pa_budget_lines pb,

757: pb.END_DATE,
758: rm.PARENT_MEMBER_ID,
759: pb.burdened_cost
760: from
761: pa_budget_lines pb,
762: pa_resource_assignments pa,
763: pa_tasks pt,
764: pa_resource_list_members rm,
765: pa_budget_versions pbv

Line 911: l_total_cc_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;

907: l_cbc_not_supported EXCEPTION;
908:
909: l_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
910: l_cc_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
911: l_total_cc_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;
912: l_total_gl_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;
913: l_rebaseline_flag VARCHAR2(1);
914: l_cc_budget_type_code VARCHAR2(30) ;
915: l_cc_encumbrance_type_id NUMBER ;

Line 912: l_total_gl_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;

908:
909: l_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
910: l_cc_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
911: l_total_cc_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;
912: l_total_gl_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;
913: l_rebaseline_flag VARCHAR2(1);
914: l_cc_budget_type_code VARCHAR2(30) ;
915: l_cc_encumbrance_type_id NUMBER ;
916:

Line 952: FROM PA_BUDGET_LINES PBL,

948: CURSOR c_budget_sum_amt(c_budget_version_id NUMBER) IS
949: SELECT sum(decode(nvl(PBL.burdened_cost,0),
950: 0,nvl(PBL.raw_cost,0),
951: PBL.burdened_cost))
952: FROM PA_BUDGET_LINES PBL,
953: PA_BUDGET_VERSIONS PBV,
954: PA_RESOURCE_ASSIGNMENTS PRA
955: WHERE PBV.project_id = p_project_id
956: AND PBV.budget_version_id = PRA.budget_version_id

Line 984: from pa_budget_lines

980:
981: --Bug 6524116
982: cursor get_rejected_event_id is
983: select bc_event_id, g_org_id
984: from pa_budget_lines
985: where budget_version_id = P_Budget_version_id
986: and bc_event_id is not null
987: union
988: select bc_rev_event_id, g_org_id

Line 989: from pa_budget_lines

985: where budget_version_id = P_Budget_version_id
986: and bc_event_id is not null
987: union
988: select bc_rev_event_id, g_org_id
989: from pa_budget_lines
990: where budget_version_id = P_prev_budget_version_id
991: and bc_rev_event_id is not null;
992:
993: BEGIN

Line 1942: from pa_budget_lines bl

1938: close get_rejected_event_id;
1939: else
1940: select bc_event_id, g_org_id
1941: bulk collect into rejected_event_id_tab, ledger_id_tab
1942: from pa_budget_lines bl
1943: where budget_version_id = P_Budget_version_id
1944: and bc_event_id is not null;
1945: end if;
1946: /*PSA_FUNDS_CHECKER_PKG.sync_xla_errors(p_failed_ldgr_array => ledger_id_tab,