APPS.OE_APPROVALS_WF dependencies on OE_APPROVER_LIST_MEMBERS

Line 544: -- from OE_APPROVER_LIST_MEMBERS

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

Line 552: from OE_APPROVER_LIST_MEMBERS

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