APPS.PAY_NZ_EFT SQL Statements

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

Line: 49

  SELECT ppa.effective_date
  FROM   pay_payroll_actions ppa
  WHERE  ppa.payroll_action_id  = c_payroll_action_id;

Line: 57

  SELECT SUBSTR(pea.segment1,3,4)||SUBSTR(LPAD(pea.segment2,8,'0'),2,7)
  FROM  pay_pre_payments ppp
       ,pay_personal_payment_methods_f ppmf
       ,pay_external_accounts  pea
  WHERE ppp.pre_payment_id             = c_pre_payment_id
  AND   ppp.personal_payment_method_id = ppmf.personal_payment_method_id
  AND   ppmf.external_account_id        = pea.external_account_id
  AND   c_effective_date  BETWEEN ppmf.effective_start_date AND ppmf.effective_end_date;

Line: 70

  SELECT hou.name
  FROM	pay_assignment_actions paa,
 	hr_organization_units hou
  WHERE paa.payroll_action_id = c_payroll_action_id
  AND	paa.assignment_action_id = c_assignment_action_id
  AND 	to_char(hou.organization_id) = paa.tax_unit_id;

Line: 81

   SELECT to_char(ptp.default_dd_date,'YYYYMMDD')
   FROM        pay_assignment_actions paa,
       pay_pre_payments ppp,
       pay_payroll_actions ppa,
       pay_action_interlocks pai,
       per_time_periods ptp
   WHERE ppp.pre_payment_id = c_pre_payment_id
   AND pai.locking_action_id = ppp.assignment_action_id
   AND paa.assignment_action_id = pai.locked_action_id
   AND ppa.payroll_action_id = paa.payroll_action_id
   AND ppa.payroll_id = ptp.payroll_id
   AND ppa.date_earned BETWEEN ptp.start_date AND ptp.end_date;