APPS.AR_ARXNROPN_XMLP_PKG SQL Statements

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

Line: 28

    select meaning
    into   HP_ORDER_BY
    from   ar_lookups
    where  lookup_type = 'ARXNROPN_ORDER_BY'
    and    lookup_code = P_ORDER_BY;

Line: 38

    select bank_account_num
    into   HP_BANK_ACCOUNT
    from   ce_bank_accounts
    where  bank_account_id = P_BANK_ACCOUNT_ID;

Line: 47

    select meaning
    into   HP_NOTE_STATUS
    from   ar_lookups
    where  lookup_type = decode(P_NOTE_STATUS,
			 'REMITTED', 'RECEIPT_CREATION_STATUS',
			 'AR_NOTE_STATUS')
    and	   lookup_code  = P_NOTE_STATUS;