eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FPA_SECURITY_PVT dependencies on PA_PROJECT_ROLE_TYPES_B

Line 201: from pa_project_parties pp, pa_project_role_types_b rlt

197: BEGIN
198:
199: select
200: pp.resource_source_id into l_person_id
201: from pa_project_parties pp, pa_project_role_types_b rlt
202: where pp.object_type = 'PJP_PORTFOLIO'
203: and pp.object_id = p_portfolio_id
204: and PP.project_role_id = rlt.project_role_id
205: and rlt.project_role_type = G_OWNER;

Line 224: from pa_project_role_types_b

220: l_role VARCHAR2(200) := null;
221: BEGIN
222: select
223: project_role_type into l_role
224: from pa_project_role_types_b
225: where project_role_id = p_project_role_id;
226:
227: return l_role;
228: EXCEPTION

Line 242: from pa_project_role_types_b

238:
239: BEGIN
240: select
241: project_role_id into l_role_id
242: from pa_project_role_types_b
243: where project_role_type = p_project_role;
244:
245: return l_role_id;
246: EXCEPTION

Line 1159: from pa_project_parties pp, pa_project_role_types_b rlt

1155: select
1156: pp.project_party_id,
1157: pp.resource_source_id,
1158: pp.project_role_id
1159: from pa_project_parties pp, pa_project_role_types_b rlt
1160: where pp.object_type = 'PJP_PORTFOLIO'
1161: and pp.object_id = p_portfolio_id
1162: and PP.project_role_id = rlt.project_role_id
1163: and rlt.project_role_type = G_OWNER;