91: PERIOD.PERIOD_NAME, PERIOD.PERIOD_TYPE,
92: PERIOD.START_DATE CONVERSION_DATE,
93: LOOKUP1.LOOKUP_CODE FROM_CURRENCY,
94: LOOKUP2.LOOKUP_CODE TO_CURRENCY
95: FROM AS_MC_TYPE_MAPPINGS TYPEMAP,
96: AS_PERIOD_DAYS PERIOD,
97: FND_LOOKUP_VALUES LOOKUP1,
98: FND_LOOKUP_VALUES LOOKUP2
99: WHERE TYPEMAP.PERIOD_SET_NAME = c_period_set_name
121: PERIOD.PERIOD_NAME, PERIOD.PERIOD_TYPE,
122: PERIOD.END_DATE CONVERSION_DATE,
123: LOOKUP1.LOOKUP_CODE FROM_CURRENCY,
124: LOOKUP2.LOOKUP_CODE TO_CURRENCY
125: FROM AS_MC_TYPE_MAPPINGS TYPEMAP,
126: AS_PERIOD_DAYS PERIOD,
127: FND_LOOKUP_VALUES LOOKUP1,
128: FND_LOOKUP_VALUES LOOKUP2
129: WHERE TYPEMAP.PERIOD_SET_NAME = c_period_set_name