APPS.PAY_NO_ADVANCE_PAY SQL Statements

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

Line: 14

      SELECT effective_date
      FROM pay_payroll_actions
      WHERE payroll_action_id = p_payroll_action_id;

Line: 19

      SELECT creator_type
      FROM pay_element_entries_f peef
      WHERE peef.element_entry_id = p_element_entry_id
      AND   p_effective_date BETWEEN peef.effective_start_date
                             AND     peef.effective_end_date;