APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PA_BUDGET_VERSIONS

Line 2183: pa_budget_versions bv,

2179: DECODE(pm.entry_level_code,'P',0,pt.top_task_id) top_task_id,
2180: pbc.resource_list_member_id
2181: FROM pa_bc_packets pbc,
2182: pa_tasks pt,
2183: pa_budget_versions bv,
2184: pa_budget_entry_methods pm
2185: WHERE pbc.packet_id = p_packet_id
2186: AND pbc.budget_version_id = bv.budget_version_id
2187: AND bv.budget_entry_method_code = pm.budget_entry_method_code

Line 7952: l_cdl_budget_version_id pa_budget_versions.budget_version_id%TYPE;

7948: l_bc_exp_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7949: l_bc_transfer_sts_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7950:
7951: l_cdl_top_task_id pa_tasks.top_task_id%TYPE;
7952: l_cdl_budget_version_id pa_budget_versions.budget_version_id%TYPE;
7953: l_cdl_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
7954: l_budget_line_id pa_bc_packets.budget_line_id%TYPE;
7955: l_budget_ccid pa_bc_packets.budget_ccid%TYPE;
7956: l_error_message_code VARCHAR2(200) := NULL;

Line 8061: pa_budget_versions bv,

8057: pbc.exp_item_id,
8058: pbc.transfer_status_code
8059: FROM pa_bc_commitments_all pbc,
8060: pa_tasks pt,
8061: pa_budget_versions bv,
8062: pa_budget_entry_methods pm
8063: WHERE pbc.document_header_id = p_doc_header_id
8064: AND pbc.document_distribution_id = DECODE(substr(p_transaction_source,1,10),'PO RECEIPT',p_doc_line_number,p_doc_distribution_id)
8065: AND pbc.expenditure_type = p_expenditure_type

Line 8081: pa_budget_versions bv,

8077: SELECT DECODE(pm.entry_level_code,'P',0,pt.top_task_id) top_task_id,
8078: bv.budget_version_id,
8079: pm.entry_level_code
8080: FROM pa_tasks pt,
8081: pa_budget_versions bv,
8082: Pa_Budget_Types bt,
8083: pa_budgetary_control_options pbct,
8084: pa_budget_entry_methods pm
8085: WHERE pt.task_id = p_task_id