APPS.OZF_REQUEST_STATUS_PVT dependencies on OZF_APPROVAL_ACCESS

Line 310: FROM jtf_rs_resource_extns res, ozf_approval_access oac

306: ORDER BY CREATION_DATE DESC;
307:
308: cursor lc_last_approver_name (pc_entity_type varchar2, pc_entity_id number) is
309: SELECT res.source_first_name || ' '|| res.source_last_name
310: FROM jtf_rs_resource_extns res, ozf_approval_access oac
311: where res.user_id = oac.approver_id
312: and oac.object_type = pc_entity_type
313: and oac.object_id = pc_entity_id
314: and oac.approval_access_id = ( select max(approval_access_id)

Line 315: from ozf_approval_access

311: where res.user_id = oac.approver_id
312: and oac.object_type = pc_entity_type
313: and oac.object_id = pc_entity_id
314: and oac.approval_access_id = ( select max(approval_access_id)
315: from ozf_approval_access
316: where oac.object_type = pc_entity_type
317: and oac.object_id = pc_entity_id );
318:
319: cursor lc_media_name ( pc_media_id number) is