APPS.PA_ROLE_STATUS_MENU_UTILS dependencies on PA_PROJECT_ROLE_TYPES_B

Line 105: -- 1. Status Level and Default Menu Id from PA_PROJECT_ROLE_TYPES_B for

101: -- 22-May-2003 Ranjana Murthy - Created
102: --
103: -- PROCEDURE get_role_status_menus
104: -- This API will return:
105: -- 1. Status Level and Default Menu Id from PA_PROJECT_ROLE_TYPES_B for
106: -- the given role_id.
107: -- 2. Tables of Status Codes, Status Type, and corresponding Menu Names
108: -- from PA_ROLE_STATUS_MENU_MAP for the given role_id.
109:

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