DBA Data[Home] [Help]

APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on DUAL

Line 993: from dual;

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

Line 1054: from dual;

1050: -- Bug 4549069
1051: if (p_horizon_start is null) then
1052: select sysdate
1053: into l_horizon_start
1054: from dual;
1055: else
1056: l_horizon_start := fnd_date.canonical_to_date(p_horizon_start);
1057: end if;
1058:

Line 1062: from dual;

1058:
1059: if (p_horizon_end is null) then
1060: select sysdate +365
1061: into l_horizon_end
1062: from dual;
1063: else
1064: l_horizon_end := fnd_date.canonical_to_date(p_horizon_end);
1065: end if;
1066:

Line 1441: FROM dual

1437:
1438: IF l_version IS NOT NULL THEN
1439: BEGIN
1440: SELECT 1 INTO l_records_exist
1441: FROM dual
1442: WHERE exists ( SELECT 1
1443: FROM msc_sup_dem_entries
1444: WHERE plan_id = -1
1445: AND publisher_order_type = 2