48: ' ' || LC3.MEANING || ' ',
49: ' ' || LC4.MEANING
50: INTO B_CRORE,B_LAKH,B_THOUSAND,B_ZERO
51: FROM
52: JA_LOOKUPS LC1,
53: JA_LOOKUPS LC2,
54: JA_LOOKUPS LC3,
55: JA_LOOKUPS LC4
56: WHERE LC1.LOOKUP_CODE = LV_CRORE
49: ' ' || LC4.MEANING
50: INTO B_CRORE,B_LAKH,B_THOUSAND,B_ZERO
51: FROM
52: JA_LOOKUPS LC1,
53: JA_LOOKUPS LC2,
54: JA_LOOKUPS LC3,
55: JA_LOOKUPS LC4
56: WHERE LC1.LOOKUP_CODE = LV_CRORE
57: AND LC1.LOOKUP_TYPE = LV_NLS_TRANS
50: INTO B_CRORE,B_LAKH,B_THOUSAND,B_ZERO
51: FROM
52: JA_LOOKUPS LC1,
53: JA_LOOKUPS LC2,
54: JA_LOOKUPS LC3,
55: JA_LOOKUPS LC4
56: WHERE LC1.LOOKUP_CODE = LV_CRORE
57: AND LC1.LOOKUP_TYPE = LV_NLS_TRANS
58: AND LC2.LOOKUP_CODE = LV_LAKH
51: FROM
52: JA_LOOKUPS LC1,
53: JA_LOOKUPS LC2,
54: JA_LOOKUPS LC3,
55: JA_LOOKUPS LC4
56: WHERE LC1.LOOKUP_CODE = LV_CRORE
57: AND LC1.LOOKUP_TYPE = LV_NLS_TRANS
58: AND LC2.LOOKUP_CODE = LV_LAKH
59: AND LC2.LOOKUP_TYPE = LV_NLS_TRANS