DBA Data[Home] [Help]

APPS.CSM_SR_EVENT_PKG dependencies on CSI_I_EXTENDED_ATTRIBS

Line 470: csi_i_extended_attribs attr

466: CURSOR l_csi_iea_values_ins_csr(p_instance_id IN NUMBER)
467: IS
468: SELECT attrval.attribute_value_id
469: FROM csi_iea_values attrval,
470: csi_i_extended_attribs attr
471: WHERE attrval.instance_id = p_instance_id
472: AND attrval.attribute_id = attr.attribute_id
473: AND SYSDATE BETWEEN NVL(attrval.active_start_date, SYSDATE) AND NVL(attrval.active_end_date, SYSDATE)
474: AND SYSDATE BETWEEN NVL(attr.active_start_date, SYSDATE) AND NVL(attr.active_end_date, SYSDATE)

Line 735: csi_i_extended_attribs attr

731: CURSOR l_csi_iea_values_del_csr(p_instance_id IN NUMBER)
732: IS
733: SELECT attrval.attribute_value_id
734: FROM csi_iea_values attrval,
735: csi_i_extended_attribs attr
736: WHERE attrval.instance_id = p_instance_id
737: AND attrval.attribute_id = attr.attribute_id
738: AND SYSDATE BETWEEN NVL(attrval.active_start_date, SYSDATE) AND NVL(attrval.active_end_date, SYSDATE)
739: AND SYSDATE BETWEEN NVL(attr.active_start_date, SYSDATE) AND NVL(attr.active_end_date, SYSDATE)