DBA Data[Home] [Help]

APPS.PA_ROLE_STATUS_MENU_UTILS dependencies on FND_MENUS

Line 123: from pa_project_role_types_b prt, fnd_menus fm

119: ,x_error_message_code OUT NOCOPY VARCHAR2) IS
120:
121: cursor csr_get_role_level_info is
122: select nvl(prt.status_level, 'SYSTEM'), fm.menu_name
123: from pa_project_role_types_b prt, fnd_menus fm
124: where prt.project_role_id = p_role_id
125: and prt.menu_id = fm.menu_id(+);
126:
127: cursor csr_get_role_status_info is

Line 130: from pa_role_status_menu_map prsm, fnd_menus fm

126:
127: cursor csr_get_role_status_info is
128: select prsm.role_status_menu_id, prsm.status_type,
129: prsm.status_code, fm.menu_name
130: from pa_role_status_menu_map prsm, fnd_menus fm
131: where prsm.role_id = p_role_id
132: and prsm.menu_id = fm.menu_id;
133:
134: l_count NUMBER := 1;