APPS.DPP_REQUEST_STATUS_PVT dependencies on DPP_APPROVAL_ACCESS

Line 234: FROM jtf_rs_resource_extns res, dpp_approval_access dac

230: ORDER BY CREATION_DATE DESC;
231:
232: cursor lc_last_approver_name (pc_entity_type varchar2, pc_transaction_header_id number) is
233: SELECT res.source_first_name || ' '|| res.source_last_name
234: FROM jtf_rs_resource_extns res, dpp_approval_access dac
235: where res.user_id = dac.approver_id
236: and dac.object_type = pc_entity_type
237: and dac.object_id = pc_transaction_header_id
238: and dac.approval_access_id = ( select max(approval_access_id)

Line 239: from dpp_approval_access

235: where res.user_id = dac.approver_id
236: and dac.object_type = pc_entity_type
237: and dac.object_id = pc_transaction_header_id
238: and dac.approval_access_id = ( select max(approval_access_id)
239: from dpp_approval_access
240: where dac.object_type = pc_entity_type
241: and dac.object_id = pc_transaction_header_id );
242:
243: cursor lc_media_name ( pc_media_id number) is