APPS.CSI_PRICING_ATTRIB_VLD_PVT dependencies on CSI_I_PRICING_ATTRIBS_H_S

Line 220: FROM csi_i_pricing_attribs_h s,

216:
217: IF p_end_date < sysdate THEN
218: SELECT MAX(t.transaction_date)
219: INTO l_transaction_date
220: FROM csi_i_pricing_attribs_h s,
221: csi_transactions t
222: WHERE s.pricing_attribute_id=p_pricing_attr_id
223: AND s.transaction_id=t.transaction_id
224: AND t.transaction_id <>nvl(p_txn_id, -99999);

Line 810: SELECT csi_i_pricing_attribs_h_s.nextval

806: RETURN NUMBER
807: IS
808: l_pricing_attrib_h_id NUMBER;
809: BEGIN
810: SELECT csi_i_pricing_attribs_h_s.nextval
811: INTO l_pricing_attrib_h_id
812: FROM dual;
813: RETURN l_pricing_attrib_h_id ;
814: EXCEPTION