DBA Data[Home] [Help]

APPS.INV_REPLENISH_COUNT_PVT dependencies on DUAL

Line 527: FROM DUAL

523:
524: BEGIN
525: SELECT 1
526: INTO l_record_exists
527: FROM DUAL
528: WHERE EXISTS(SELECT 1
529: FROM mtl_replenish_lines
530: WHERE replenishment_header_id = p_replenish_header_id
531: AND count_quantity IS NULL

Line 543: FROM DUAL

539:
540: BEGIN
541: SELECT 1
542: INTO l_error_record_exists
543: FROM DUAL
544: WHERE EXISTS(
545: SELECT 1
546: FROM mtl_replenish_lines mrl
547: WHERE replenishment_header_id = p_replenish_header_id

Line 690: FROM DUAL

686: END IF;
687:
688: SELECT 2
689: INTO l_count_valid
690: FROM DUAL
691: WHERE EXISTS(
692: SELECT 1
693: FROM mtl_replenish_lines
694: WHERE replenishment_header_id = p_replenish_header_id