APPS.IGI_ITR_PREP_APPRV_PKG SQL Statements

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

Line: 36

  SELECT nvl(authorization_limit, 0)
  INTO   l_limit
  FROM   GL_AUTHORIZATION_LIMITS
  WHERE  employee_id = p_employee_id
    AND  ledger_id = p_set_of_books_id;

Line: 87

   SELECT   abs(nvl(ITRL.entered_dr,0) - nvl(ITRL.entered_cr,0))
   INTO     l_cc_approval_amt
   FROM     IGI_ITR_CHARGE_LINES ITRL
   WHERE    ITRL.it_header_id = p_cc_id
   AND      ITRL.it_line_num = p_cc_line_num;

Line: 96

    SELECT employee_id
    INTO   l_preparer_id
    FROM   fnd_user
    WHERE  user_id = p_preparer_fnd_user_id;

Line: 105

    SELECT nvl(originator_approve_flag,'N')
    INTO   l_originator_approve
    FROM   igi_itr_charge_setup
    WHERE  set_of_books_id = p_sob_id;