APPS.OPI_DBI_PTP_BASELINE_PKG dependencies on DUAL

Line 264: FROM dual;

260: l_rate := 1;
261: ELSE
262: SELECT fii_currency.get_global_rate_primary(l_currency_code, g_sysdate)
263: INTO l_rate
264: FROM dual;
265: END IF;
266:
267: IF (l_currency_code = g_secondary_currency_code) THEN
268: l_secondary_rate := 1;

Line 539: FROM dual;

535: l_rate := 1;
536: ELSE
537: SELECT fii_currency.get_global_rate_primary(l_currency_code, g_sysdate)
538: INTO l_rate
539: FROM dual;
540: END IF;
541:
542: IF (l_currency_code = g_secondary_currency_code) THEN
543: l_secondary_rate := 1;

Line 574: from dual

570: :l_rate conversion_rate,
571: :l_secondary_rate sec_conversion_rate,
572: :g_sysdate from_date,
573: null to_date
574: from dual
575: ) new_conv
576: on
577: ( conv.organization_id = new_conv.organization_id
578: and conv.conversion_rate = new_conv.conversion_rate

Line 1098: SELECT BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE INTO g_global_start_date FROM DUAL;

1094: g_sysdate := trunc(sysdate);
1095: g_created_by := nvl(fnd_global.user_id, -1);
1096: g_last_update_login := nvl(fnd_global.login_id, -1);
1097: g_last_updated_by := nvl(fnd_global.user_id, -1);
1098: SELECT BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE INTO g_global_start_date FROM DUAL;
1099: SELECT bis_common_parameters.get_currency_code INTO g_global_currency_code FROM dual;
1100: IF g_global_currency_code IS NULL THEN
1101: RAISE intialization_exception;
1102: END IF;

Line 1099: SELECT bis_common_parameters.get_currency_code INTO g_global_currency_code FROM dual;

1095: g_created_by := nvl(fnd_global.user_id, -1);
1096: g_last_update_login := nvl(fnd_global.login_id, -1);
1097: g_last_updated_by := nvl(fnd_global.user_id, -1);
1098: SELECT BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE INTO g_global_start_date FROM DUAL;
1099: SELECT bis_common_parameters.get_currency_code INTO g_global_currency_code FROM dual;
1100: IF g_global_currency_code IS NULL THEN
1101: RAISE intialization_exception;
1102: END IF;
1103: