35: ' ' || LC3.DISPLAYED_FIELD || ' ',
36: ' ' || LC4.DISPLAYED_FIELD
37: INTO B_CRORE,B_LAKH,B_THOUSAND,B_ZERO
38: FROM
39: AP_LOOKUP_CODES LC1,
40: AP_LOOKUP_CODES LC2,
41: AP_LOOKUP_CODES LC3,
42: AP_LOOKUP_CODES LC4
43: WHERE LC1.LOOKUP_CODE = 'CRORE'
36: ' ' || LC4.DISPLAYED_FIELD
37: INTO B_CRORE,B_LAKH,B_THOUSAND,B_ZERO
38: FROM
39: AP_LOOKUP_CODES LC1,
40: AP_LOOKUP_CODES LC2,
41: AP_LOOKUP_CODES LC3,
42: AP_LOOKUP_CODES LC4
43: WHERE LC1.LOOKUP_CODE = 'CRORE'
44: AND LC1.LOOKUP_TYPE = 'NLS TRANSLATION'
37: INTO B_CRORE,B_LAKH,B_THOUSAND,B_ZERO
38: FROM
39: AP_LOOKUP_CODES LC1,
40: AP_LOOKUP_CODES LC2,
41: AP_LOOKUP_CODES LC3,
42: AP_LOOKUP_CODES LC4
43: WHERE LC1.LOOKUP_CODE = 'CRORE'
44: AND LC1.LOOKUP_TYPE = 'NLS TRANSLATION'
45: AND LC2.LOOKUP_CODE = 'LAKH'
38: FROM
39: AP_LOOKUP_CODES LC1,
40: AP_LOOKUP_CODES LC2,
41: AP_LOOKUP_CODES LC3,
42: AP_LOOKUP_CODES LC4
43: WHERE LC1.LOOKUP_CODE = 'CRORE'
44: AND LC1.LOOKUP_TYPE = 'NLS TRANSLATION'
45: AND LC2.LOOKUP_CODE = 'LAKH'
46: AND LC2.LOOKUP_TYPE = 'NLS TRANSLATION'