APPS.PAY_IE_ADVANCE_PAY SQL Statements

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

Line: 13

         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;