APPS.OE_APPROVALS_WF dependencies on OE_APPROVER_LISTS

Line 302: the role from the OE_APPROVER_LISTS with approver_sequence = max+1

298: the definition/setup in the OM Approver List form, insert/update
299: the proper record in the OM Approval transaction table
300: OE_APPROVAL_TRANSACTIONS. Checks the max(approver_sequence) from
301: OE_APPROVAL_TRANSACTIONS given a transaction_id, and then fetches
302: the role from the OE_APPROVER_LISTS with approver_sequence = max+1
303: and insert the record in OE_APPROVER_TRANSACTIONS.
304: Returns Y if it finds the next approver and returns N if there is no
305: approver left. In the case there is no more approvers, it will update
306: the status to APPROVED

Line 601: from OE_APPROVER_LISTS

597: -- Get the approver list_id
598: BEGIN
599: select list_id
600: into l_list_id
601: from OE_APPROVER_LISTS
602: where TRANSACTION_TYPE_ID = l_transaction_type_id
603: and TRANSACTION_PHASE_CODE is not NULL
604: and TRANSACTION_PHASE_CODE = l_transaction_phase_code
605: and SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE )

Line 625: from OE_APPROVER_LISTS

621:
622: BEGIN
623: select list_id
624: into l_list_id
625: from OE_APPROVER_LISTS
626: where TRANSACTION_TYPE_ID = l_transaction_type_id
627: and TRANSACTION_PHASE_CODE is NULL
628: and SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE )
629: AND NVL(END_DATE_ACTIVE, SYSDATE );