DBA Data[Home] [Help]

APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on DUAL

Line 996: from dual;

992: into l_user_id,
993: l_user_name --,
994: --l_resp_name,
995: --l_application_name
996: from dual;
997: end if;
998:
999: if l_user_id is null then
1000: l_language_code := 'US';

Line 1070: from dual;

1066: -- Bug 4549069
1067: if (p_horizon_start is null) then
1068: select sysdate
1069: into l_horizon_start
1070: from dual;
1071: else
1072: l_horizon_start := fnd_date.canonical_to_date(p_horizon_start);
1073: end if;
1074:

Line 1078: from dual;

1074:
1075: if (p_horizon_end is null) then
1076: select sysdate +365
1077: into l_horizon_end
1078: from dual;
1079: else
1080: l_horizon_end := fnd_date.canonical_to_date(p_horizon_end);
1081: end if;
1082:

Line 1457: FROM dual

1453:
1454: IF l_version IS NOT NULL THEN
1455: BEGIN
1456: SELECT 1 INTO l_records_exist
1457: FROM dual
1458: WHERE exists ( SELECT 1
1459: FROM msc_sup_dem_entries
1460: WHERE plan_id = -1
1461: AND publisher_order_type = 2