APPS.PQP_GB_TP_TYPE2_FUNCTIONS SQL Statements

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

Line: 377

       p_tab_ele_ids.delete;

Line: 1178

     g_add_cont_ele_ids.delete;

Line: 1554

  select decode(sign(get_add_cont_value(p_assignment_id)),-1,1,0)
    from dual;

Line: 1619

  select sum(dtl.val_10) total_value
    from ben_ext_rslt_dtl dtl
        --,ben_ext_rcd      rcd
  where  dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
    and  dtl.ext_rcd_id  = p_ext_rcd_id;

Line: 1681

  select decode(sign(g_total_add_cont),-1,1,0)
    from dual;