APPS.PA_SECURITY_PVT dependencies on PA_PROJECT_ROLE_TYPES_B

Line 431: pa_project_role_types_b roletypes

427: select 'Y'
428: from fnd_user users,
429: pa_project_parties ppp,
430: --pa_project_role_types roletypes --bug 4004821
431: pa_project_role_types_b roletypes
432: where decode (p_source_type, 'PERSON', users.employee_id,
433: 'HZ_PARTY', users.person_party_id) -- Bug 4527617. Replaced customer_id with person_party_id.
434: = ppp.resource_source_id
435: and ppp.resource_type_id= decode(p_source_type,'PERSON',101,

Line 1638: pa_project_role_types_b role --Bug 4867700

1634: select menu.menu_name
1635: into v_menu_name
1636: from fnd_menus menu,
1637: --pa_project_role_types role
1638: pa_project_role_types_b role --Bug 4867700
1639: where menu.menu_id=role.menu_id
1640: and role.project_role_id= p_project_role_id;
1641: return v_menu_name;
1642: exception

Line 1734: from pa_project_role_types_b

1730: l_api_name varchar2(30):='get_menu_id_for_role';
1731: begin
1732: select menu_id into v_menu_id
1733: --from pa_project_role_types --bug 4004821
1734: from pa_project_role_types_b
1735: where project_role_id =p_project_role_id;
1736: return v_menu_id;
1737: exception
1738: when no_data_found then

Line 2507: p_status_level IN pa_project_role_types_b.status_level%TYPE,

2503: PROCEDURE update_status_based_sec
2504: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2505: p_debug_mode in varchar2 default 'N',
2506: p_project_role_id IN number,
2507: p_status_level IN pa_project_role_types_b.status_level%TYPE,
2508: p_new_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2509: p_new_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2510: p_new_menu_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2511: p_new_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,