DBA Data[Home] [Help]

APPS.AR_ARXNROPN_XMLP_PKG dependencies on AR_LOOKUPS

Line 30: from ar_lookups

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

Line 49: from ar_lookups

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;