APPS.PA_SELF_SERVICE_MSG_PUB SQL Statements

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

Line: 105

   SELECT sum(nvl(quantity_1,0)) qty_1,
          sum(nvl(quantity_2,0)) qty_2,
          sum(nvl(quantity_3,0)) qty_3,
          sum(nvl(quantity_4,0)) qty_4,
          sum(nvl(quantity_5,0)) qty_5,
          sum(nvl(quantity_6,0)) qty_6,
          sum(nvl(quantity_7,0)) qty_7,
          sum(decode(ei.billable_flag_1,'Y',ei.quantity_1,0)) bill_qty_1,
          sum(decode(ei.billable_flag_2,'Y',ei.quantity_2,0)) bill_qty_2,
          sum(decode(ei.billable_flag_3,'Y',ei.quantity_3,0)) bill_qty_3,
          sum(decode(ei.billable_flag_4,'Y',ei.quantity_4,0)) bill_qty_4,
          sum(decode(ei.billable_flag_5,'Y',ei.quantity_5,0)) bill_qty_5,
          sum(decode(ei.billable_flag_6,'Y',ei.quantity_6,0)) bill_qty_6,
          sum(decode(ei.billable_flag_7,'Y',ei.quantity_7,0)) bill_qty_7
    from pa_expenditures exp,
         pa_ei_denorm ei
   where ei.expenditure_id = exp.expenditure_id
     and exp.expenditure_id = p_expenditure_id
     and exp.incurred_by_person_id = p_person_id
     and exp.expenditure_ending_date = p_week_ending_date;