DBA Data[Home] [Help]

APPS.AR_ARXPOMR_XMLP_PKG dependencies on AR_LOOKUPS

Line 23: FROM ar_lookups

19: elsif po_name = 'AR_SHOW_BILLING_NUMBER' then
20: begin
21: SELECT meaning
22: INTO l_meaning
23: FROM ar_lookups
24: WHERE lookup_type = 'YES/NO'
25: and lookup_code = po_value;
26: exception when others then
27: null;

Line 33: from AR_LOOKUPS

29: elsif po_name = 'AR_DOC_SEQ_GEN_LEVEL' then
30: begin
31: select MEANING
32: into l_meaning
33: from AR_LOOKUPS
34: where lookup_type='DOC_SEQ_GEN_LEVEL'
35: and lookup_code = po_value;
36: exception when others then
37: null;

Line 44: FROM ar_lookups

40:
41: begin
42: SELECT meaning
43: INTO l_meaning
44: FROM ar_lookups
45: WHERE lookup_type = 'PA_CODE'
46: and to_number(decode(lookup_code,'UNDEFINED','-1',lookup_code))
47: = DECODE(po_value,'UNDEFINED',-1,po_value);
48: exception when others then

Line 56: from AR_LOOKUPS

52: elsif po_name = 'AR_ZENGIN_CHAR_SET' then
53: begin
54: select MEANING
55: into l_meaning
56: from AR_LOOKUPS
57: where lookup_type = 'AR_ZENGIN_CHAR_SET'
58: and lookup_code = po_value;
59: exception when others then
60: null;