APPS.DPP_REQUEST_STATUS_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 212: , jtf_rs_resource_extns creator

208: , dtha.days_covered,
209: dtha.transaction_status
210: from dpp_transaction_headers_all dtha
211: , ap_suppliers asp
212: , jtf_rs_resource_extns creator
213: , dpp_lookups lkup
214: , ap_supplier_sites_all assa
215: where dtha.transaction_header_id = pc_header_id
216: and dtha.vendor_id = asp.vendor_id

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)