[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'
829: SUM( decode(pkt.document_type, 'PO', nvl(pkt.burdenable_raw_cost,0), 0 ) ) po_brc,
830: SUM( decode(pkt.document_type, 'REQ',nvl(pkt.burdenable_raw_cost,0), 0 ) ) req_brc,
831: SUM( decode(pkt.document_type, 'AP', nvl(pkt.burdenable_raw_cost,0), 0 ) ) ap_brc
832: FROM GMS_BC_PACKETS PKT,
833: gms_budget_versions gbv
834: WHERE pkt.award_id = p_award_id
835: and pkt.expenditure_type = p_exp_type
836: and pkt.status_code in ('A', 'P','I' )
837: and burden_calculation_seq > 0
1150: l_stage := 'Derive Budget Version';
1151:
1152: Select budget_version_id
1153: into l_budget_version_id
1154: from gms_budget_versions
1155: where award_id = x_rec_log.award_id
1156: and project_id = p_project_id
1157: and budget_status_code ='B'
1158: and current_flag = 'Y';
4179: END IF;
4180:
4181: Update gms_bc_packets bcp
4182: set bcp.budget_version_id = (select gbv.budget_version_id
4183: from gms_budget_versions gbv
4184: where gbv.award_id = bcp.award_id
4185: and gbv.project_id = bcp.project_id
4186: and gbv.budget_status_code ='B'
4187: and gbv.current_flag = 'Y'