DBA Data[Home] [Help]

APPS.JA_JAINITCR_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 39: AP_LOOKUP_CODES LC1,

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'

Line 40: AP_LOOKUP_CODES LC2,

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'

Line 41: AP_LOOKUP_CODES LC3,

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'

Line 42: AP_LOOKUP_CODES LC4

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'