APPS.IBC_CV_LABEL_GRP dependencies on IBC_CITEM_VERSIONS_B

Line 663: SELECT '1' INTO l_temp FROM ibc_citem_versions_b

659: -- Exists in database
660: --
661: FOR i IN p_content_item_ids.FIRST..p_content_item_ids.LAST
662: LOOP
663: SELECT '1' INTO l_temp FROM ibc_citem_versions_b
664: WHERE content_item_id = p_content_item_ids(i)
665: AND citem_version_id = l_citem_version_ids(i);
666: END LOOP;
667: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 685: FROM ibc_citem_versions_b

681: FOR i IN p_content_item_ids.FIRST..p_content_item_ids.LAST
682: LOOP
683: l_citem_version_ids.extend;
684: SELECT citem_version_id INTO l_citem_version_ids(i)
685: FROM ibc_citem_versions_b
686: WHERE content_item_id = p_content_item_ids(i)
687: AND version_number = p_version_number(i);
688: END LOOP;
689: EXCEPTION WHEN NO_DATA_FOUND THEN