DBA Data[Home] [Help]

APPS.HR_IT_EXTRA_ASSGT_RULES SQL Statements

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

Line: 40

        SELECT lookup_code
        INTO   l_emp_cat
        FROM   hr_lookups
        WHERE  lookup_type = 'IT_EMP_CAT'
          AND  lookup_code = p_employment_category;