APPS.PAY_NO_PAYPROC_UTILITY SQL Statements

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

Line: 13

select paf.DEFAULT_PAYMENT_METHOD_ID
from pay_payrolls_f paf
where paf.payroll_id = p_payroll_id
  and p_effective_date between paf.effective_start_date and paf.effective_end_date;

Line: 39

select ppm.external_account_id
from pay_personal_payment_methods_f ppm
where ppm.personal_payment_method_id=p_personal_method_id
 and p_effective_date between ppm.effective_start_date and ppm.effective_end_date;

Line: 46

select paf.DEFAULT_PAYMENT_METHOD_ID
from pay_payrolls_f paf
where paf.payroll_id = p_payroll_id
 and p_effective_date between paf.effective_start_date and paf.effective_end_date;

Line: 70

      select ppm.external_account_id into l_account_id
      from pay_personal_payment_methods_f ppm
      where ppm.personal_payment_method_id=l_personal_method_id
        and p_effective_date between ppm.effective_start_date and ppm.effective_end_date;

Line: 90

select ppm.external_account_id
from pay_personal_payment_methods_f ppm
where ppm.personal_payment_method_id=p_personal_method_id
  and p_effective_date between ppm.effective_start_date and ppm.effective_end_date;

Line: 125

SELECT legislative_parameters
FROM   pay_payroll_actions
WHERE  payroll_action_id = p_pact_id;