APPS.OZF_REQUEST_STATUS_PVT dependencies on OZF_APPROVAL_ACCESS

Line 302: FROM jtf_rs_resource_extns res, ozf_approval_access oac

298: ORDER BY CREATION_DATE DESC;
299:
300: cursor lc_last_approver_name (pc_entity_type varchar2, pc_entity_id number) is
301: SELECT res.source_first_name || ' '|| res.source_last_name
302: FROM jtf_rs_resource_extns res, ozf_approval_access oac
303: where res.user_id = oac.approver_id
304: and oac.object_type = pc_entity_type
305: and oac.object_id = pc_entity_id
306: and oac.approval_access_id = ( select max(approval_access_id)

Line 307: from ozf_approval_access

303: where res.user_id = oac.approver_id
304: and oac.object_type = pc_entity_type
305: and oac.object_id = pc_entity_id
306: and oac.approval_access_id = ( select max(approval_access_id)
307: from ozf_approval_access
308: where oac.object_type = pc_entity_type
309: and oac.object_id = pc_entity_id );
310:
311: cursor lc_media_name ( pc_media_id number) is