APPS.PER_KR_EXTRA_ASSIGNMENT_RULES SQL Statements

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

Line: 12

    select  'Y'
    from    hr_kr_establishments_v
    where   organization_id = p_establishment_id
    and     p_effective_date
            between date_from and nvl(date_to, p_effective_date);