APPS.AR_OBALREV_PKG SQL Statements

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

Line: 53

  SELECT hp.party_name
    INTO gc_customer_name
    FROM hz_parties hp
        ,hz_cust_accounts hca
   WHERE hca.party_id = hp.party_id
     AND hca.account_number = P_CUSTOMER;

Line: 64

  SELECT GL1.ledger_id
        ,GL1.currency_code
    INTO gc_ledger_id
        ,gc_func_currency
    FROM gl_ledgers                  GL1
        ,gl_access_set_norm_assign   GASNA
   WHERE GASNA.access_set_id     = FND_PROFILE.VALUE('GL_ACCESS_SET_ID')
     AND GL1.ledger_id          = GASNA.ledger_id
     AND GL1.ledger_category_code = 'PRIMARY';

Line: 80

   SELECT name
   INTO gc_ou_name
   FROM hr_operating_units
   WHERE organization_id = p_org_id;

Line: 90

   SELECT gdct.user_conversion_type
    INTO gc_exchange_rate_type
    FROM gl_daily_conversion_types  gdct
   WHERE gdct.conversion_type     = P_EXCHANGE_RATE_TYPE;