26: end;
27: begin
28: select meaning
29: into HP_ORDER_BY
30: from ar_lookups
31: where lookup_type = 'ARXNROPN_ORDER_BY'
32: and lookup_code = P_ORDER_BY;
33: exception
34: when NO_DATA_FOUND
45: end;
46: begin
47: select meaning
48: into HP_NOTE_STATUS
49: from ar_lookups
50: where lookup_type = decode(P_NOTE_STATUS,
51: 'REMITTED', 'RECEIPT_CREATION_STATUS',
52: 'AR_NOTE_STATUS')
53: and lookup_code = P_NOTE_STATUS;