DBA Data[Home] [Help]

APPS.OPI_EDW_INV_DAILY_STAT_F_C dependencies on DUAL

Line 167: FROM dual;

163:
164: IF l_org_date_csr%rowcount = 1 THEN
165: SELECT edw_util.get_base_currency(l_org_date.organization_id)
166: INTO l_base_currency_code
167: FROM dual;
168:
169: l_prev_org_id := l_org_date.organization_id;
170:
171: --dbms_output.put_line(' in l_org_date, ' || l_org_date.organization_id || l_org_date.trx_date );

Line 177: FROM dual;

173:
174: IF l_prev_org_id <> l_org_date.organization_id THEN
175: SELECT edw_util.get_base_currency(l_org_date.organization_id)
176: INTO l_base_currency_code
177: FROM dual;
178:
179: l_prev_org_id := l_org_date.organization_id;
180: l_org_conv_rate_flag := TRUE;
181:

Line 193: FROM dual;

189: l_org_date.trx_date,
190: l_rate_type,
191: 1000 )
192: INTO l_conv_rate
193: FROM dual;
194: EXCEPTION
195: WHEN OTHERS THEN
196: l_trx_date := l_org_date.trx_date;
197: