APPS.IGI_IGIRRTRH_XMLP_PKG SQL Statements

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

Line: 38

                             		select nvl(min(x.due_date), TO_DATE(''01/01/0001'',''MM/DD/YYYY''))
                               		from ar_payment_schedules x
                                		 where x.customer_trx_id = ps.customer_trx_id)
                             			and ps.cons_inv_id = ci.cons_inv_id(+)';

Line: 95

      SELECT
        INITCAP(LOOK1.MEANING) C_YES,
        INITCAP(LOOK2.MEANING) C_NO
      INTO L_YES,L_NO
      FROM
        AR_LOOKUPS LOOK1,
        AR_LOOKUPS LOOK2
      WHERE LOOK1.LOOKUP_TYPE = 'YES/NO'
        AND LOOK1.LOOKUP_CODE = 'Y'
        AND LOOK2.LOOKUP_TYPE = 'YES/NO'
        AND LOOK2.LOOKUP_CODE = 'N';

Line: 109

      SELECT
        CP.USER_CONCURRENT_PROGRAM_NAME
      INTO L_REPORT_NAME
      FROM
        FND_CONCURRENT_PROGRAMS_TL CP,
        FND_CONCURRENT_REQUESTS CR
      WHERE CR.REQUEST_ID = P_CONC_REQUEST_ID
        AND CP.LANGUAGE = USERENV('LANG')
        AND CP.APPLICATION_ID = CR.PROGRAM_APPLICATION_ID
        AND CP.CONCURRENT_PROGRAM_ID = CR.CONCURRENT_PROGRAM_ID;

Line: 201

      SELECT
        DECODE(UPPER(P_START_CURRENCY_CODE)
              ,NULL
              ,MIN(CUST.INVOICE_CURRENCY_CODE)
              ,UPPER(P_START_CURRENCY_CODE)),
        DECODE(UPPER(P_END_CURRENCY_CODE)
              ,NULL
              ,MAX(CUST.INVOICE_CURRENCY_CODE)
              ,UPPER(P_END_CURRENCY_CODE))
      INTO L_START_CURRENCY_CODE,L_END_CURRENCY_CODE
      FROM
        RA_CUSTOMER_TRX CUST
      WHERE CUST.COMPLETE_FLAG = 'Y';

Line: 251

    SELECT
      RTRIM(RPAD(MEANING
                ,11))
    INTO L_MEANING
    FROM
      AR_LOOKUPS
    WHERE LOOKUP_TYPE = L_TYPE
      AND LOOKUP_CODE = L_CODE;

Line: 267

    SELECT
      MEANING
    INTO W_MEANING
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
      AND LOOKUP_CODE = P_LOOKUP_CODE;

Line: 1034

                               ,LAST_UPDATE_LOGIN IN NUMBER) IS
  BEGIN
    STPROC.INIT('begin ARP_STANDARD.SET_WHO_INFORMATION(:USER_ID, :REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, :LAST_UPDATE_LOGIN); end;');

Line: 1041

    STPROC.BIND_I(LAST_UPDATE_LOGIN);