APPS.PAY_US_W2C_IN_MMREF2_FORMAT SQL Statements

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

Line: 773

          parameter_record.delete;

Line: 1095

          parameter_record.delete;

Line: 1366

   pay_us_w2c_in_mmref2_format.ltr_rct_info.delete;

Line: 1376

   pay_us_w2c_in_mmref2_format.ltr_rcu_info.delete;

Line: 1405

SELECT TO_CHAR(effective_date,'YYYY')
FROM pay_assignment_actions paa,pay_payroll_actions ppa
WHERE ppa.payroll_action_id = paa.payroll_action_id
  AND paa.assignment_action_id = p_assign_action_id;

Line: 2099

   pay_us_w2c_in_mmref2_format.ltr_rcw_info.delete;

Line: 2276

   parameter_record.delete;

Line: 2390

   rcw_compared_rec.delete;

Line: 2487

   pay_us_w2c_in_mmref2_format.ltr_rco_info.delete;

Line: 2519

   parameter_record.delete;

Line: 2577

   rco_compared_rec.delete;