APPS.IBE_CATALOG_PVT dependencies on IBE_DSP_MSITE_SCT_SECTS

Line 573: FROM IBE_DSP_MSITE_SCT_SECTS mss, IBE_DSP_SECTIONS_B jdsb

569: -- API Body
570: IF FND_API.to_Boolean(l_preview_flag) THEN
571: OPEN x_leafsubsectid_csr FOR
572: SELECT mss.child_section_id, mss.sort_order
573: FROM IBE_DSP_MSITE_SCT_SECTS mss, IBE_DSP_SECTIONS_B jdsb
574: WHERE mss.mini_site_id = p_msite_id
575: AND mss.child_section_id in
576: ( SELECT mss1.child_section_id
577: FROM IBE_DSP_MSITE_SCT_SECTS mss1

Line 577: FROM IBE_DSP_MSITE_SCT_SECTS mss1

573: FROM IBE_DSP_MSITE_SCT_SECTS mss, IBE_DSP_SECTIONS_B jdsb
574: WHERE mss.mini_site_id = p_msite_id
575: AND mss.child_section_id in
576: ( SELECT mss1.child_section_id
577: FROM IBE_DSP_MSITE_SCT_SECTS mss1
578: START WITH mss1.parent_section_id = p_sectid and mss1.mini_site_id = p_msite_id
579: CONNECT BY PRIOR mss1.child_section_id = mss1.parent_section_id
580: AND mss1.mini_site_id = p_msite_id
581: )

Line 585: FROM IBE_DSP_MSITE_SCT_SECTS mss2

581: )
582: AND mss.child_section_id not in
583: (
584: SELECT mss2.parent_section_id
585: FROM IBE_DSP_MSITE_SCT_SECTS mss2
586: WHERE mss2.mini_site_id = p_msite_id
587: AND mss2.parent_section_id is not null
588: )
589: AND jdsb.section_id = mss.child_section_id

Line 597: FROM IBE_DSP_MSITE_SCT_SECTS mss, IBE_DSP_SECTIONS_B jdsb

593: ORDER BY mss.sort_order;
594: ELSE
595: OPEN x_leafsubsectid_csr FOR
596: SELECT mss.child_section_id, mss.sort_order
597: FROM IBE_DSP_MSITE_SCT_SECTS mss, IBE_DSP_SECTIONS_B jdsb
598: WHERE mss.mini_site_id = p_msite_id
599: AND mss.child_section_id in
600: ( SELECT mss1.child_section_id
601: FROM IBE_DSP_MSITE_SCT_SECTS mss1

Line 601: FROM IBE_DSP_MSITE_SCT_SECTS mss1

597: FROM IBE_DSP_MSITE_SCT_SECTS mss, IBE_DSP_SECTIONS_B jdsb
598: WHERE mss.mini_site_id = p_msite_id
599: AND mss.child_section_id in
600: ( SELECT mss1.child_section_id
601: FROM IBE_DSP_MSITE_SCT_SECTS mss1
602: START WITH mss1.parent_section_id = p_sectid and mss1.mini_site_id = p_msite_id
603: CONNECT BY PRIOR mss1.child_section_id = mss1.parent_section_id
604: AND mss1.mini_site_id = p_msite_id
605: )

Line 609: FROM IBE_DSP_MSITE_SCT_SECTS mss2

605: )
606: AND mss.child_section_id not in
607: (
608: SELECT mss2.parent_section_id
609: FROM IBE_DSP_MSITE_SCT_SECTS mss2
610: WHERE mss2.mini_site_id = p_msite_id
611: AND mss2.parent_section_id is not null
612: )
613: AND jdsb.section_id = mss.child_section_id

Line 759: FROM IBE_DSP_MSITE_SCT_SECTS mss

755: ----------------------
756:
757: OPEN x_supersectid_csr FOR
758: SELECT mss.parent_section_id
759: FROM IBE_DSP_MSITE_SCT_SECTS mss
760: START WITH mss.child_section_id = p_sectid AND mss.mini_site_id = p_msite_id
761: CONNECT BY PRIOR mss.parent_section_id = mss.child_section_id
762: AND mss.mini_site_id = p_msite_id;
763: