APPS.PER_EIT_UTILITY_SS SQL Statements

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

Line: 20

        select application_id
        from fnd_application
        where application_short_name = upper(P_APPLICATION_SHORT_NAME);

Line: 24

        select responsibility_id
        from fnd_responsibility_vl
        where responsibility_name = P_RESPONSIBILITY_NAME
        and application_id = l_appl_id;

Line: 31

        select  1
        from    PER_INFO_TYPE_SECURITY t
        where   t.application_id = c1_p_appl_id
        and     t.responsibility_id = c1_p_resp_id
        and     t.info_type_table_name = P_INFO_TYPE_TABLE_NAME
        and     t.information_type = P_INFORMATION_TYPE
        and     (P_ROWID        is null
                 or P_ROWID    <> t.rowid);

Line: 70

        select application_id
        from fnd_application
        where application_short_name = upper(P_APPLICATION_SHORT_NAME);

Line: 74

        select responsibility_key
        from fnd_responsibility_vl
        where responsibility_name = resp_resp_name
        and   application_id = resp_appl_id;

Line: 104

select information_type
from per_people_info_types
where information_type not like 'GHR%';

Line: 109

select information_type
from per_job_info_types
where information_type not like 'GHR%';

Line: 114

select information_type
from per_assignment_info_types
where information_type not like 'GHR%';

Line: 119

select information_type
from per_position_info_types
where information_type not like 'GHR%';

Line: 124

select information_type
from hr_location_info_types
where information_type not like 'GHR%';

Line: 144

PER_PEOPLE_INFO_TYPES_SEC_PKG.INSERT_ROW
(x_rowid 			=> l_row_id,
 x_application_short_name 	=> 'PER',
 --X_RESPONSIBILITY_NAME 		=> P_RESPONSIBILITY_NAME,
 X_RESPONSIBILITY_KEY           => GET_RESP_KEY('PER', P_RESPONSIBILITY_NAME),
 X_INFO_TYPE_TABLE_NAME 	=> 'PER_PEOPLE_INFO_TYPES',
 X_INFORMATION_TYPE		=> person_type.information_type,
 X_OBJECT_VERSION_NUMBER 	=> 1,
 X_CREATION_DATE		=> sysdate,
 X_CREATED_BY			=> -1,
 X_LAST_UPDATE_DATE 		=> sysdate,
 X_LAST_UPDATED_BY		=> -1,
 X_LAST_UPDATE_LOGIN		=> -1);

Line: 173

PER_PEOPLE_INFO_TYPES_SEC_PKG.INSERT_ROW
(x_rowid 			=> l_row_id,
 x_application_short_name 	=> 'PER',
 --X_RESPONSIBILITY_NAME                => P_RESPONSIBILITY_NAME,
 X_RESPONSIBILITY_KEY           => GET_RESP_KEY('PER', P_RESPONSIBILITY_NAME),
 X_INFO_TYPE_TABLE_NAME 	=> 'PER_JOB_INFO_TYPES',
 X_INFORMATION_TYPE		=> job_type.information_type,
 X_OBJECT_VERSION_NUMBER 	=> 1,
 X_CREATION_DATE		=> sysdate,
 X_CREATED_BY			=> -1,
 X_LAST_UPDATE_DATE 		=> sysdate,
 X_LAST_UPDATED_BY		=> -1,
 X_LAST_UPDATE_LOGIN		=> -1);

Line: 204

PER_PEOPLE_INFO_TYPES_SEC_PKG.INSERT_ROW
(x_rowid 			=> l_row_id,
 x_application_short_name 	=> 'PER',
 --X_RESPONSIBILITY_NAME                => P_RESPONSIBILITY_NAME,
 X_RESPONSIBILITY_KEY           => GET_RESP_KEY('PER', P_RESPONSIBILITY_NAME),
 X_INFO_TYPE_TABLE_NAME 	=> 'PER_ASSIGNMENT_INFO_TYPES',
 X_INFORMATION_TYPE		=> assignment_type.information_type,
 X_OBJECT_VERSION_NUMBER 	=> 1,
 X_CREATION_DATE		=> sysdate,
 X_CREATED_BY			=> -1,
 X_LAST_UPDATE_DATE 		=> sysdate,
 X_LAST_UPDATED_BY		=> -1,
 X_LAST_UPDATE_LOGIN		=> -1);

Line: 235

PER_PEOPLE_INFO_TYPES_SEC_PKG.INSERT_ROW
(x_rowid 			=> l_row_id,
 x_application_short_name 	=> 'PER',
 --X_RESPONSIBILITY_NAME                => P_RESPONSIBILITY_NAME,
 X_RESPONSIBILITY_KEY           => GET_RESP_KEY('PER', P_RESPONSIBILITY_NAME),
 X_INFO_TYPE_TABLE_NAME 	=> 'PER_POSITION_INFO_TYPES',
 X_INFORMATION_TYPE		=> position_type.information_type,
 X_OBJECT_VERSION_NUMBER 	=> 1,
 X_CREATION_DATE		=> sysdate,
 X_CREATED_BY			=> -1,
 X_LAST_UPDATE_DATE 		=> sysdate,
 X_LAST_UPDATED_BY		=> -1,
 X_LAST_UPDATE_LOGIN		=> -1);

Line: 266

PER_PEOPLE_INFO_TYPES_SEC_PKG.INSERT_ROW
(x_rowid 			=> l_row_id,
 x_application_short_name 	=> 'PER',
 --X_RESPONSIBILITY_NAME                => P_RESPONSIBILITY_NAME,
 X_RESPONSIBILITY_KEY           => GET_RESP_KEY('PER', P_RESPONSIBILITY_NAME),
 X_INFO_TYPE_TABLE_NAME 	=> 'HR_LOCATION_INFO_TYPES',
 X_INFORMATION_TYPE		=> location_type.information_type,
 X_OBJECT_VERSION_NUMBER 	=> 1,
 X_CREATION_DATE		=> sysdate,
 X_CREATED_BY			=> -1,
 X_LAST_UPDATE_DATE 		=> sysdate,
 X_LAST_UPDATED_BY		=> -1,
 X_LAST_UPDATE_LOGIN		=> -1);