APPS.IBE_CATALOG_PVT dependencies on IBE_DSP_SECTIONS_B

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 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 1149: 'FROM IBE_CT_RELATION_RULES rr, IBE_DSP_SECTIONS_B jdsb ' ||

1145:
1146: IF p_dest_type = 'S' THEN
1147: IF FND_API.to_Boolean(l_preview_flag) THEN
1148: l_relobj_stmt := 'SELECT rr.DEST_OBJECT_ID ' ||
1149: 'FROM IBE_CT_RELATION_RULES rr, IBE_DSP_SECTIONS_B jdsb ' ||
1150: 'WHERE rr.ORIGIN_OBJECT_TYPE = :p_origintype ' ||
1151: 'AND rr.ORIGIN_OBJECT_ID = :p_originid ' ||
1152: 'AND rr.RELATION_TYPE_CODE = :p_reltype_code ' ||
1153: 'AND rr.DEST_OBJECT_TYPE = :p_dest_type ' ||

Line 1160: 'FROM IBE_CT_RELATION_RULES rr, IBE_DSP_SECTIONS_B jdsb ' ||

1156: 'AND NVL(jdsb.start_date_active, SYSDATE) <= SYSDATE ' ||
1157: 'AND NVL(jdsb.end_date_active, SYSDATE) >= SYSDATE ';
1158: ELSE
1159: l_relobj_stmt := 'SELECT rr.DEST_OBJECT_ID ' ||
1160: 'FROM IBE_CT_RELATION_RULES rr, IBE_DSP_SECTIONS_B jdsb ' ||
1161: 'WHERE rr.ORIGIN_OBJECT_TYPE = :p_origintype ' ||
1162: 'AND rr.ORIGIN_OBJECT_ID = :p_originid ' ||
1163: 'AND rr.RELATION_TYPE_CODE = :p_reltype_code ' ||
1164: 'AND rr.DEST_OBJECT_TYPE = :p_dest_type ' ||