APPS.BIS_FN_SECURITY SQL Statements

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

Line: 14

    SELECT me.function_id, me.sub_menu_id
    FROM (SELECT m.menu_id, m.function_id, m.sub_menu_id,
                 decode(m.function_id, NULL, 'M', 'F') entry_type
          FROM fnd_menu_entries m
          WHERE m.menu_id = x_menu_id) me,
          fnd_resp_functions ex
    WHERE ex.responsibility_id (+) = p_responsibility_id
    AND   ex.rule_type(+) = me.entry_type
    AND   ex.action_id(+) <> decode(me.entry_type, 'F', me.function_id,
                                              'M', me.sub_menu_id, null);

Line: 26

    SELECT menu_id
    FROM fnd_responsibility
    WHERE responsibility_id = p_responsibility_id
    AND   start_date <= sysdate
    AND   (nvl(end_date, sysdate) >= sysdate);