APPS.PAY_JP_MAGTAPE_FORMAT_PKG SQL Statements

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

Line: 24

     SELECT 'Y' into l_product_release
      FROM fnd_application a, fnd_application_tl t, fnd_product_installations p
     WHERE a.application_id = p.application_id
       AND a.application_id = t.application_id
       AND t.language = Userenv ('LANG')
       AND Substr (a.application_short_name, 1, 5) = 'PAY'
       and substr(p.patch_level,1,7) = 'R12.PAY'
       and substr(p.patch_level,9,1) <> 'A';

Line: 34

		select  nvl(PMETH_INFORMATION4,'NONE') into l_delimiter
		  from pay_org_payment_methods_f
		 where EXTERNAL_ACCOUNT_ID = p_data.external_account_id
          and p_data.direct_deposit_date between effective_start_date and effective_end_date;