APPS.PAY_KR_RULES SQL Statements

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

Line: 15

   08-FEB-2006  mmark       115.3  4913403   Updated procedure GET_DYNAMIC_ORG_METH
                                             - Removed cursor CSR_EFF_DATE
                                             - Used language from userenv('LANG')
*/
--
--
   procedure get_default_run_type(p_asg_id   in number,
                                  p_ee_id    in number,
                                  p_effdate  in date,
                                  p_run_type out NOCOPY varchar2)
   is
     l_run_type_id number;

Line: 28

    select run_type_id
      into l_run_type_id
      from pay_run_types_f
     where run_type_name = 'MTH'
       and p_effdate between effective_start_date
                         and effective_end_date;

Line: 50

                select  ppmtl.org_payment_method_name
                from
                        pay_org_payment_methods_f_tl ppmtl,
                        pay_org_payment_methods_f ppm
                where
                        ppmtl.org_payment_method_id = p_org_meth
                        and ppm.org_payment_method_id = p_org_meth
                        and ppm.external_account_id is null
                        and ppmtl.language = userenv('LANG')
                        and p_effective_date between ppm.effective_start_date and ppm.effective_end_date ;