APPS.DPP_REQUEST_STATUS_PVT dependencies on DPP_APPROVAL_ACCESS

Line 236: FROM jtf_rs_resource_extns res, dpp_approval_access dac

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

Line 241: from dpp_approval_access

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