APPS.GML_PO_COST_DTL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

PROCEDURE select_summary(x_po_header_id     IN     NUMBER,
                         x_po_line_id       IN     NUMBER,
                         x_line_location_id IN     NUMBER,
                         x_total            IN OUT NUMBER,
                         x_total_rtot_db    IN OUT NUMBER) IS

BEGIN
select nvl(sum(cost_amount), 0), nvl(sum(cost_amount), 0)
            into x_total, x_total_rtot_db
            from cpg_cost_dtl
           where po_header_id = x_po_header_id
             and po_line_id = x_po_line_id
             and line_location_id = x_line_location_id;

Line: 34

END SELECT_SUMMARY;