APPS.PAY_FR_SICK_PAY_PROCESSING SQL Statements

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

Line: 431

      SELECT creator_id ID
      FROM   pay_element_entries_f
      WHERE  element_entry_id = p_element_entry_id
        AND  creator_type     = 'A'
        AND  creator_id       IS NOT NULL;

Line: 737

select decode(l_target_net,0,1,l_target_net) into l_init from dual;