DBA Data[Home] [Help]

APPS.JA_JAINCINI_XMLP_PKG dependencies on JA_LOOKUPS

Line 52: JA_LOOKUPS LC1,

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

Line 53: JA_LOOKUPS LC2,

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

Line 54: JA_LOOKUPS LC3,

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

Line 55: JA_LOOKUPS LC4

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