APPS.CSI_EXTEND_ATTRIB_VLD_PVT dependencies on CSI_IEA_VALUES_H_S

Line 484: FROM csi_iea_values_h s,

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

Line 711: SELECT csi_iea_values_h_s.nextval

707: RETURN NUMBER
708: IS
709: l_attribute_value_id NUMBER;
710: BEGIN
711: SELECT csi_iea_values_h_s.nextval
712: INTO l_attribute_value_id
713: FROM dual;
714: RETURN l_attribute_value_id;
715: EXCEPTION