APPS.PAY_PAYVIBAL_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 33

                                        expensive select within LOOP.
 40.2    05-OCT-93 RFine                prepended 'PAY_' to package name
 40.4    11-OCT-95 JThuringer           Removed spurious end of comment marker
 =================================================================
*/
--
--
procedure get_dimension_contexts(p_route_id in number, p_context1 out varchar2,
                                                    p_context2 out varchar2,
                                                    p_context3 out varchar2) IS
cursor c_route_context_usage is
    SELECT c.context_name
    ,      u.sequence_no
    from   ff_contexts c
    ,      ff_route_context_usages u
    where  u.route_id = p_route_id
    and    c.context_id = u.context_id
    order by u.sequence_no;