APPS.HR_BUILD_NAME_TRG_PKG SQL Statements

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

Line: 20

    SELECT legislation_code
    FROM   hr_legislation_installations
    WHERE  application_short_name = 'PER'
		   AND ( (status='I' OR action IS NOT NULL)
                         or (legislation_code = 'JP') -- Added for fix of #3290184
                       )
	ORDER BY legislation_code;

Line: 30

    SELECT object_name
    FROM user_objects
    WHERE object_type='PACKAGE BODY'
      AND object_name LIKE 'HR_'||(p_lgsl_cd)||'_UTILITY'
      AND length(object_name)=13
    ORDER BY object_name;

Line: 40

    SELECT text
    FROM user_source
    WHERE name = p_pkb_name
    and type = 'PACKAGE' --Bug# 2858437
    ORDER BY line;

Line: 87

    'BEFORE INSERT OR UPDATE ON PER_ALL_PEOPLE_F FOR EACH ROW ' ||
    'DECLARE l_legislation_code VARCHAR2(2); BEGIN '        ||