APPS.PA_DEDUCTIONS_PUB SQL Statements

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

Line: 52

        SELECT segment1
        FROM   PO_HEADERS_ALL
        WHERE  PO_HEADER_ID = p_po_header_id;

Line: 57

        SELECT ci_number,
               DECODE(ci_type_class_code,'CHANGE_ORDER', 'Change Order',
                                         'CHANGE_REQUEST', 'Change Request') document_type
        FROM   PA_CONTROL_ITEMS citem,
               PA_CI_TYPES_VL ctype
        WHERE  citem.ci_type_id = ctype.ci_type_id
        AND    citem.ci_id = p_ci_id;

Line: 119

        SELECT PA_DEDUCTIONS_S.nextval
        INTO   l_ded_req_id
        FROM   DUAL;

Line: 314

      SELECT *
      FROM   PA_DEDUCTIONS_ALL
      WHERE  deduction_req_num = c_deduction_req_num
      AND    status = 'WORKING';

Line: 414

        SELECT PA_DEDUCTION_TXNS_S.nextval
        INTO   l_deduction_req_tran_id
        FROM   DUAL;