APPS.OE_APPROVALS_WF dependencies on OE_APPROVER_LIST_MEMBERS

Line 546: -- from OE_APPROVER_LIST_MEMBERS

542:
543: -- Get the next approver_sequence and its role
544: -- cursor c_get_next_approver (m_cur_seq number, m_list_id number) is
545: -- select ROLE, APPROVER_SEQUENCE
546: -- from OE_APPROVER_LIST_MEMBERS
547: -- where list_id = m_list_id
548: -- and APPROVER_SEQUENCE > m_cur_seq
549: -- and ACTIVE_FLAG = 'Y'
550: -- order by APPROVER_SEQUENCE;

Line 554: from OE_APPROVER_LIST_MEMBERS

550: -- order by APPROVER_SEQUENCE;
551:
552: cursor c_get_next_approver is
553: select ROLE, APPROVER_SEQUENCE
554: from OE_APPROVER_LIST_MEMBERS
555: where list_id = l_list_id
556: and APPROVER_SEQUENCE > l_curr_approver_sequence
557: and ACTIVE_FLAG = 'Y'
558: order by APPROVER_SEQUENCE;