APPS.PAY_IP_ROUTE_SUPPORT SQL Statements

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

Line: 19

     SELECT TO_DATE(ru.rule_mode || '/' || TO_CHAR(p_effective_date, 'YYYY'), 'DD/MM/YYYY')
     FROM   per_business_groups   bg
           ,pay_legislation_rules ru
     WHERE  bg.business_group_id = p_business_group_id
       AND  ru.legislation_code  = bg.legislation_code
       AND  ru.rule_type         = 'L';

Line: 96

     SELECT TO_DATE(TO_CHAR(fnd_date.canonical_to_date(hoi.org_information11), 'DD/MM/')
                 || TO_CHAR(p_effective_date, 'YYYY'), 'DD/MM/YYYY')
     FROM   hr_organization_information HOI
     WHERE  UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'
       AND  hoi.organization_id                = p_business_group_id;