APPS.PA_SECURITY_PVT dependencies on PA_PROJECT_ROLE_TYPES_B

Line 441: pa_project_role_types_b roletypes

437: select 'Y'
438: from fnd_user users,
439: pa_project_parties ppp,
440: --pa_project_role_types roletypes --bug 4004821
441: pa_project_role_types_b roletypes
442: where decode (p_source_type, 'PERSON', users.employee_id,
443: 'HZ_PARTY', users.person_party_id) -- Bug 4527617. Replaced customer_id with person_party_id.
444: = ppp.resource_source_id
445: and ppp.resource_type_id= decode(p_source_type,'PERSON',101,

Line 1649: pa_project_role_types_b role --Bug 4867700

1645: select menu.menu_name
1646: into v_menu_name
1647: from fnd_menus menu,
1648: --pa_project_role_types role
1649: pa_project_role_types_b role --Bug 4867700
1650: where menu.menu_id=role.menu_id
1651: and role.project_role_id= p_project_role_id;
1652: return v_menu_name;
1653: exception

Line 1745: from pa_project_role_types_b

1741: l_api_name varchar2(30):='get_menu_id_for_role';
1742: begin
1743: select menu_id into v_menu_id
1744: --from pa_project_role_types --bug 4004821
1745: from pa_project_role_types_b
1746: where project_role_id =p_project_role_id;
1747: return v_menu_id;
1748: exception
1749: when no_data_found then

Line 2518: p_status_level IN pa_project_role_types_b.status_level%TYPE,

2514: PROCEDURE update_status_based_sec
2515: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2516: p_debug_mode in varchar2 default 'N',
2517: p_project_role_id IN number,
2518: p_status_level IN pa_project_role_types_b.status_level%TYPE,
2519: p_new_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2520: p_new_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2521: p_new_menu_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2522: p_new_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,