DBA Data[Home] [Help]

APPS.AS_PERIOD_RATES_REFRESH dependencies on FND_LOOKUP_VALUES

Line 97: FND_LOOKUP_VALUES LOOKUP1,

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
100: AND TYPEMAP.PERIOD_TYPE = PERIOD.PERIOD_TYPE
101: AND PERIOD.PERIOD_SET_NAME = c_period_set_name

Line 98: FND_LOOKUP_VALUES LOOKUP2

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
100: AND TYPEMAP.PERIOD_TYPE = PERIOD.PERIOD_TYPE
101: AND PERIOD.PERIOD_SET_NAME = c_period_set_name
102: AND PERIOD.PERIOD_DAY = PERIOD.START_DATE

Line 127: FND_LOOKUP_VALUES LOOKUP1,

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
130: AND TYPEMAP.PERIOD_TYPE = PERIOD.PERIOD_TYPE
131: AND PERIOD.PERIOD_SET_NAME = c_period_set_name

Line 128: FND_LOOKUP_VALUES LOOKUP2

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
130: AND TYPEMAP.PERIOD_TYPE = PERIOD.PERIOD_TYPE
131: AND PERIOD.PERIOD_SET_NAME = c_period_set_name
132: AND PERIOD.PERIOD_DAY = PERIOD.END_DATE