APPS.IBC_ASSOCIATIONS_GRP dependencies on IBC_CONTENT_ITEMS

Line 573: -- WHERE NOT EXISTS (SELECT NULL FROM IBC_CONTENT_ITEMS C

569: --
570: -- CURSOR c1 IS
571: -- SELECT A.COLUMN_VALUE A_content_item_id
572: -- FROM TABLE(CAST(p_content_item_ids AS JTF_NUMBER_TABLE)) AS A
573: -- WHERE NOT EXISTS (SELECT NULL FROM IBC_CONTENT_ITEMS C
574: -- WHERE a.column_value=c.content_item_id);
575: --
576:
577: CURSOR cur_old_citem IS

Line 581: SELECT content_item_id FROM IBC_CONTENT_ITEMS C;

577: CURSOR cur_old_citem IS
578: SELECT A.COLUMN_VALUE content_item_id
579: FROM TABLE(CAST(p_old_content_item_ids AS JTF_NUMBER_TABLE)) A
580: MINUS
581: SELECT content_item_id FROM IBC_CONTENT_ITEMS C;
582:
583: CURSOR cur_new_citem IS
584: SELECT A.COLUMN_VALUE content_item_id
585: FROM TABLE(CAST(p_new_content_item_ids AS JTF_NUMBER_TABLE)) A

Line 587: SELECT content_item_id FROM IBC_CONTENT_ITEMS C;

583: CURSOR cur_new_citem IS
584: SELECT A.COLUMN_VALUE content_item_id
585: FROM TABLE(CAST(p_new_content_item_ids AS JTF_NUMBER_TABLE)) A
586: MINUS
587: SELECT content_item_id FROM IBC_CONTENT_ITEMS C;
588:
589: CURSOR cur_old_citem_version IS
590: SELECT A.COLUMN_VALUE citem_version_id
591: FROM TABLE(CAST(p_old_citem_version_ids AS JTF_NUMBER_TABLE)) A