[Home] [Help]
323: and adl.adl_line_num = 1
324: and adl.po_distribution_id = pod.po_distribution_id
325: --
326: -- 4004559 - PJ.M:B8:P13:OTH:PERF: FULL TABLE SCAN COST ON PO_DISTRIBUTIONS_ALL EXCEEDS 5
327: -- gms_budget_versions criteria was added so that index can be used.
328: -- and full table scan on po_distributions_all is gone.
329: --
330: and pod.project_id in ( select gbv.project_id
331: from gms_budget_versions gbv
327: -- gms_budget_versions criteria was added so that index can be used.
328: -- and full table scan on po_distributions_all is gone.
329: --
330: and pod.project_id in ( select gbv.project_id
331: from gms_budget_versions gbv
332: where gbv.budget_type_code = 'AC'
333: and gbv.budget_status_code in ('S','W' )
334: and gbv.award_id = p_award_id )
335: and adl.adl_status = 'A'
562: SUM( decode(pkt.document_type, 'PO', nvl(pkt.burdenable_raw_cost,0), 0 ) ) po_brc,
563: SUM( decode(pkt.document_type, 'REQ',nvl(pkt.burdenable_raw_cost,0), 0 ) ) req_brc,
564: SUM( decode(pkt.document_type, 'AP', nvl(pkt.burdenable_raw_cost,0), 0 ) ) ap_brc
565: FROM GMS_BC_PACKETS PKT,
566: gms_budget_versions gbv
567: WHERE pkt.award_id = p_award_id
568: and pkt.expenditure_type = p_exp_type
569: and pkt.status_code in ('A', 'P','I' )
570: and burden_calculation_seq > 0
883: l_stage := 'Derive Budget Version';
884:
885: Select budget_version_id
886: into l_budget_version_id
887: from gms_budget_versions
888: where award_id = x_rec_log.award_id
889: and project_id = p_project_id
890: and budget_status_code ='B'
891: and current_flag = 'Y';
3797: END IF;
3798:
3799: Update gms_bc_packets bcp
3800: set bcp.budget_version_id = (select gbv.budget_version_id
3801: from gms_budget_versions gbv
3802: where gbv.award_id = bcp.award_id
3803: and gbv.project_id = bcp.project_id
3804: and gbv.budget_status_code ='B'
3805: and gbv.current_flag = 'Y'