DBA Data[Home] [Help]

APPS.CSI_MASS_EDIT_PUB dependencies on CSI_I_VERSION_LABELS

Line 5149: FROM csi_i_version_labels cil1

5145: IF l_instance.VERSION_LABEL IS NOT NULL THEN
5146: BEGIN
5147: SELECT cil1.VERSION_LABEL
5148: INTO l_old_version_label
5149: FROM csi_i_version_labels cil1
5150: WHERE cil1.instance_id = l_instance.INSTANCE_ID
5151: AND nvl(cil1.DATE_TIME_STAMP, sysdate) = nvl ( (SELECT max(cil2.DATE_TIME_STAMP)
5152: FROM csi_i_version_labels cil2
5153: WHERE cil2.instance_id = cil1.instance_id ) , sysdate );

Line 5152: FROM csi_i_version_labels cil2

5148: INTO l_old_version_label
5149: FROM csi_i_version_labels cil1
5150: WHERE cil1.instance_id = l_instance.INSTANCE_ID
5151: AND nvl(cil1.DATE_TIME_STAMP, sysdate) = nvl ( (SELECT max(cil2.DATE_TIME_STAMP)
5152: FROM csi_i_version_labels cil2
5153: WHERE cil2.instance_id = cil1.instance_id ) , sysdate );
5154:
5155: EXCEPTION
5156: when no_data_found then