DBA Data[Home] [Help]

APPS.IGS_CO_PROCESS dependencies on IBC_COMPOUND_RELATIONS

Line 871: FROM ibc_compound_relations

867: --Cursor to get the citem_version_id
868: CURSOR c_check_relation (cp_item_id ibc_citem_versions_b.content_item_id%TYPE,
869: cp_version_id ibc_citem_versions_b.version_number%TYPE) IS
870: SELECT 'Y'
871: FROM ibc_compound_relations
872: WHERE CITEM_VERSION_ID = (SELECT CITEM_VERSION_ID FROM ibc_citem_versions_b
873: WHERE CONTENT_ITEM_ID = cp_item_id AND
874: VERSION_NUMBER = cp_version_id)
875: AND ATTRIBUTE_TYPE_CODE = 'QUERY'; -- ssawhney modified after OCM migration.