APPS.PAY_HRMS_ACCESS_PKG SQL Statements

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

Line: 14

    Select
          LEGISLATION_CODE       -- which is set by datainstall utility.
      from HR_LEGISLATION_INSTALLATIONS
        where STATUS is null and ACTION is not null
           or STATUS = 'I' and ACTION is not null;

Line: 26

    Select
          OBJECT_NAME
       from ALL_OBJECTS
         where OBJECT_NAME = 'FND_INSTALL_PROCESSES'
           and OBJECT_TYPE ='TABLE'
           and OWNER = p_fnd_schema;

Line: 34

    select
	PARAMETER_VALUE
    from PAY_ACTION_PARAMETERS
    where PARAMETER_NAME = 'HRLEGDEL_SLEEP';

Line: 87

    l_stmt_fnd_install_data := 'select count(worker_id) from fnd_install_processes where status =''F''';