APPS.CSI_EXTEND_ATTRIB_VLD_PVT dependencies on CSI_IEA_VALUES_H_S

Line 486: FROM csi_iea_values_h s,

482:
483: IF p_end_date < sysdate THEN
484: SELECT MAX(t.transaction_date)
485: INTO l_transaction_date
486: FROM csi_iea_values_h s,
487: csi_transactions t
488: WHERE s.attribute_value_id=p_attr_value_id
489: AND s.transaction_id=t.transaction_id
490: AND t.transaction_id <> nvl(p_txn_id, -99999);

Line 715: SELECT csi_iea_values_h_s.nextval

711: RETURN NUMBER
712: IS
713: l_attribute_value_id NUMBER;
714: BEGIN
715: SELECT csi_iea_values_h_s.nextval
716: INTO l_attribute_value_id
717: FROM dual;
718: RETURN l_attribute_value_id;
719: EXCEPTION