DBA Data[Home] [Help]

APPS.JA_JAINITCR_XMLP_PKG dependencies on JA_LOOKUPS

Line 33: ' ' || LC1.meaning || ' ', --Changed from ap_lookup_codes to ja_lookups for Bug#5930605

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

Line 34: ' ' || LC2.meaning || ' ', --Changed from ap_lookup_codes to ja_lookups for Bug#5930605

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

Line 35: ' ' || LC3.meaning || ' ', --Changed from ap_lookup_codes to ja_lookups for Bug#5930605

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

Line 36: ' ' || LC4.meaning --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

Line 39: ja_lookups LC1, --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'

Line 40: ja_lookups LC2, --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'
44: AND LC1.LOOKUP_TYPE = 'JAI_NLS_TRANSLATION' --Modified for bug# 5930605

Line 41: ja_lookups LC3, --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
45: AND LC2.LOOKUP_CODE = 'LAKH'

Line 42: ja_lookups LC4 --Changed from ap_lookup_codes to ja_lookups for Bug#5930605

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