APPS.MTL_SAFETY_STOCKS_PKG dependencies on DUAL

Line 22: FROM dual

18: l_return_sts BOOLEAN := FALSE;
19: BEGIN
20: SELECT 1
21: INTO l_num
22: FROM dual
23: WHERE EXISTS (SELECT 1
24: FROM mtl_safety_stocks
25: WHERE organization_id = p_organization_id
26: AND inventory_item_id = p_inventory_item_id

Line 578: FROM DUAL;

574: /********************************************************/
575:
576: SELECT TO_NUMBER(TO_CHAR(effect_date, 'J'))
577: INTO j_effect_date
578: FROM DUAL;
579:
580: /********************************************************/
581: /* pro_sqty: Processing Safety Stock Qty. */
582: /* pro_sdate: Processing Safety Stock Effectivity Date. */