APPS.PA_ROLE_STATUS_MENU_UTILS SQL Statements

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

Line: 26

select 'Y'
from   pa_role_status_menu_map
where  role_id = p_role_id
and    status_code = p_status_code
and    status_type = 'PROJECT'
and    role_status_menu_id <> nvl(p_role_status_menu_id, -99);

Line: 69

select 'Y'
from   pa_role_status_menu_map
where  status_code = p_status_code
and    status_type = 'PROJECT';

Line: 122

select nvl(prt.status_level, 'SYSTEM'), fm.menu_name
from   pa_project_role_types_b prt, fnd_menus fm
where  prt.project_role_id = p_role_id
and    prt.menu_id = fm.menu_id(+);

Line: 128

select prsm.role_status_menu_id, prsm.status_type,
       prsm.status_code, fm.menu_name
from   pa_role_status_menu_map prsm, fnd_menus fm
where  prsm.role_id = p_role_id
and    prsm.menu_id = fm.menu_id;