DBA Data[Home] [Help]

APPS.IRC_PARTY_SWI dependencies on FND_RESPONSIBILITY

Line 1217: (select resp.menu_id from fnd_responsibility resp

1213: select fe.function_id
1214: from fnd_menu_entries fe
1215: where fe.function_id is not null
1216: start with fe.menu_id=
1217: (select resp.menu_id from fnd_responsibility resp
1218: where resp.responsibility_key=p_responsibility_key)
1219: connect by prior fe.sub_menu_id= fe.menu_id
1220: and fe.grant_flag='Y'
1221: order by level,fe.entry_sequence;

Line 1234: (select resp.menu_id from fnd_responsibility resp

1230: from fnd_menu_entries fe
1231: where 'HOMEPAGE'=(select fm.type from fnd_menus fm
1232: where fm.menu_id=fe.menu_id)
1233: start with fe.menu_id=
1234: (select resp.menu_id from fnd_responsibility resp
1235: where resp.responsibility_key=p_responsibility_key)
1236: connect by prior fe.sub_menu_id= fe.menu_id
1237: and fe.grant_flag='Y'
1238: order by level,fe.entry_sequence;