DBA Data[Home] [Help]

APPS.HRI_BPL_SECURITY SQL Statements

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

Line: 19

SELECT 1
FROM fnd_responsibility
WHERE application_id = 453
AND responsibility_key = 'HRI_DBI_CHIEF_HR_OFFICER'
AND fnd_global.resp_id = responsibility_id;
Line: 62

SELECT responsibility_key
FROM FND_RESPONSIBILITY
WHERE responsibility_id = p_resp_id
AND application_id = p_resp_appl_id;