APPS.IBC_VALIDATE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26

        SELECT
            citem_version_id
        FROM
            ibc_citem_versions_b
        WHERE
            citem_version_id = f_citem_ver_id
        AND
            citem_version_status = IBC_UTILITIES_PUB.G_STV_APPROVED;

Line: 64

        SELECT
            content_item_id
        FROM
            ibc_content_items
        WHERE
            content_item_id = f_citem_id
        AND
            content_item_status = IBC_UTILITIES_PUB.G_STI_APPROVED;

Line: 193

        SELECT
            association_id
        FROM
            ibc_associations
        WHERE
            association_id = f_assoc_id;

Line: 233

        SELECT
            file_id
        FROM
    	    fnd_lobs
        WHERE
            file_id = f_attach_id;

Line: 272

        SELECT
            association_type_code
        FROM
	       ibc_association_types_b
        WHERE
            association_type_code = f_assoc_code;

Line: 313

        SELECT
            attribute_type_code
        FROM
	       ibc_attribute_types_b
        WHERE
            attribute_type_code = f_attr_type_code
        AND
            content_type_code = f_ctype_code;

Line: 355

        SELECT
            citem_version_id
        FROM
	       ibc_citem_versions_b
        WHERE
            citem_version_id = f_citem_ver_id;

Line: 396

        SELECT citem_version_id
          FROM ibc_citem_versions_b
         WHERE content_item_id = f_citem_id
           AND citem_version_id = f_citem_ver_id;

Line: 432

        SELECT
            content_item_id
        FROM
	       ibc_content_items
        WHERE
            content_item_id = f_citem_id;

Line: 470

        SELECT 'X'
          FROM fnd_languages
         WHERE language_code = p_language;

Line: 505

        SELECT
            content_type_code
        FROM
	       ibc_content_types_b
        WHERE
            content_type_code = f_ctype_code;

Line: 544

        SELECT
           directory_node_id
        FROM
	       ibc_directory_nodes_b
        WHERE
            directory_node_id = f_node_id;

Line: 585

        SELECT
           file_id
        FROM
	       fnd_lobs
        WHERE
            file_id = f_lob_id;

Line: 624

        SELECT resource_id
          FROM jtf_rs_all_resources_vl
         WHERE resource_id = f_resource_id
           AND resource_type = f_resource_type;

Line: 632

        SELECT user_id
          FROM FND_USER
         WHERE user_id = f_resource_id;

Line: 680

        SELECT user_id
          FROM FND_USER
         WHERE user_id = f_user_id;

Line: 743

        SELECT
            LABEL_CODE
        FROM
	        IBC_LABELS_B
        WHERE
            LABEL_CODE = f_label;

Line: 850

 SELECT lookup_code
 FROM   ibc_lookups lk
 WHERE  lookup_type = 'IBC_CTYPE_STATUS'
 AND    lookup_code = p_Content_Type_Status;

Line: 894

SELECT  application_id
FROM    fnd_application_vl
WHERE   application_short_name = x_short_name;

Line: 936

SELECT  application_id
FROM    fnd_application_vl
WHERE   application_id = p_application_id;

Line: 980

SELECT  '1'
FROM    ibc_content_types_vl
WHERE   content_type_code = p_content_type_code;

Line: 1023

 SELECT lookup_code
 FROM   ibc_lookups lk
 WHERE  lookup_type = 'IBC_ATTRIBUTE_DATA_TYPE'
 AND    lookup_code = p_Data_type_Code;

Line: 1107

       SELECT content_item_id
       FROM   ibc_content_items
       WHERE  content_item_id = TO_NUMBER(p_default_value);

Line: 1132

       SELECT file_id
       FROM   fnd_lobs
       WHERE  file_id = p_default_value;

Line: 1247

 SELECT '1'
   FROM JTF_RS_GROUPS_VL
  WHERE group_id = p_resource_id;

Line: 1296

        SELECT
            citem_version_id
        FROM
            ibc_citem_versions_tl
        WHERE
            citem_version_id = f_citem_ver_id
        AND language = f_language
        AND citem_translation_status = IBC_UTILITIES_PUB.G_STV_APPROVED;

Line: 1330

        SELECT
            base_language
        FROM
            ibc_content_items
        WHERE
            content_item_id = f_content_item_id;