APPS.PAY_KR_YEA_CONC_PKG SQL Statements

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

Line: 30

       SELECT payroll_action_id
         FROM pay_payroll_actions
        WHERE request_id           = l_bal_req_id
          AND payroll_id           = p_payroll_id
          AND consolidation_set_id = p_consolidation_set_id
          AND effective_date       = l_effective_date;