29: ,MAX_DIGIT) THEN
30: RAISE NUMBER_TOO_LARGE;
31: END IF;
32: SELECT
33: ' ' || LC1.meaning || ' ', --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
34: ' ' || LC2.meaning || ' ', --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
35: ' ' || LC3.meaning || ' ', --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
36: ' ' || LC4.meaning --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
37: INTO B_CRORE,B_LAKH,B_THOUSAND,B_ZERO
30: RAISE NUMBER_TOO_LARGE;
31: END IF;
32: SELECT
33: ' ' || LC1.meaning || ' ', --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
34: ' ' || LC2.meaning || ' ', --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
35: ' ' || LC3.meaning || ' ', --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
36: ' ' || LC4.meaning --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
37: INTO B_CRORE,B_LAKH,B_THOUSAND,B_ZERO
38: FROM
31: END IF;
32: SELECT
33: ' ' || LC1.meaning || ' ', --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
34: ' ' || LC2.meaning || ' ', --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
35: ' ' || LC3.meaning || ' ', --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
36: ' ' || LC4.meaning --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
37: INTO B_CRORE,B_LAKH,B_THOUSAND,B_ZERO
38: FROM
39: ja_lookups LC1, --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
32: SELECT
33: ' ' || LC1.meaning || ' ', --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
34: ' ' || LC2.meaning || ' ', --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
35: ' ' || LC3.meaning || ' ', --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
36: ' ' || LC4.meaning --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
37: INTO B_CRORE,B_LAKH,B_THOUSAND,B_ZERO
38: FROM
39: ja_lookups LC1, --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
40: ja_lookups LC2, --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
35: ' ' || LC3.meaning || ' ', --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
36: ' ' || LC4.meaning --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
37: INTO B_CRORE,B_LAKH,B_THOUSAND,B_ZERO
38: FROM
39: ja_lookups LC1, --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
40: ja_lookups LC2, --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
41: ja_lookups LC3, --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
42: ja_lookups LC4 --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
43: WHERE LC1.LOOKUP_CODE = 'CRORE'
36: ' ' || LC4.meaning --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
37: INTO B_CRORE,B_LAKH,B_THOUSAND,B_ZERO
38: FROM
39: ja_lookups LC1, --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
40: ja_lookups LC2, --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
41: ja_lookups LC3, --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
42: ja_lookups LC4 --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
43: WHERE LC1.LOOKUP_CODE = 'CRORE'
44: AND LC1.LOOKUP_TYPE = 'JAI_NLS_TRANSLATION' --Modified for bug# 5930605
37: INTO B_CRORE,B_LAKH,B_THOUSAND,B_ZERO
38: FROM
39: ja_lookups LC1, --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
40: ja_lookups LC2, --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
41: ja_lookups LC3, --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
42: ja_lookups LC4 --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
43: WHERE LC1.LOOKUP_CODE = 'CRORE'
44: AND LC1.LOOKUP_TYPE = 'JAI_NLS_TRANSLATION' --Modified for bug# 5930605
45: AND LC2.LOOKUP_CODE = 'LAKH'
38: FROM
39: ja_lookups LC1, --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
40: ja_lookups LC2, --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
41: ja_lookups LC3, --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
42: ja_lookups LC4 --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
43: WHERE LC1.LOOKUP_CODE = 'CRORE'
44: AND LC1.LOOKUP_TYPE = 'JAI_NLS_TRANSLATION' --Modified for bug# 5930605
45: AND LC2.LOOKUP_CODE = 'LAKH'
46: AND LC2.LOOKUP_TYPE = 'JAI_NLS_TRANSLATION' -- Modified for bug# 5930605