APPS.MSD_ITEM_RELATIONSHIPS_PKG dependencies on DUAL

Line 557: FROM dual;

553: l_seq_id := null;
554:
555: SELECT msd_event_products_s.nextval
556: INTO l_seq_id
557: FROM dual;
558:
559: /* Insert new items into MSD_EVENT_PRODUCTS table */
560:
561: msd_item_relationships_pkg.insert_event_products(

Line 605: from dual;

601: l_relation_id := NULL;
602:
603: select msd_evt_prod_relationships_s.nextval
604: into l_relation_id
605: from dual;
606:
607: l_qty_mod_type := 2;
608: l_qty_mod_factor := 0;
609: l_npi_prd_relshp := 1;

Line 632: from dual;

628: l_relation_id := NULL;
629:
630: select msd_evt_prod_relationships_s.nextval
631: into l_relation_id
632: from dual;
633:
634: select msd_evt_product_details_s.nextval
635: into l_detail_id
636: from dual;

Line 636: from dual;

632: from dual;
633:
634: select msd_evt_product_details_s.nextval
635: into l_detail_id
636: from dual;
637:
638: l_qty_mod_type := 2;
639: l_qty_mod_factor := 100;
640: l_npi_prd_relshp := 2;