APPS.CSI_PRICING_ATTRIB_VLD_PVT dependencies on CSI_I_PRICING_ATTRIBS

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 286: FROM csi_i_pricing_attribs

282: RETURN FALSE;
283: ELSE
284: SELECT '1'
285: INTO l_pricing_attrib_id
286: FROM csi_i_pricing_attribs
287: WHERE pricing_attribute_id = p_pricing_attrib_id;
288: IF ( p_stack_err_msg = TRUE ) THEN
289: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PRI_ATT_ID');
290: FND_MESSAGE.SET_TOKEN('PRICING_ATTRIB_ID',p_pricing_attrib_id);

Line 572: FROM csi_i_pricing_attribs

568: p_pricing_attribs_rec.attribute13,
569: p_pricing_attribs_rec.attribute14,
570: p_pricing_attribs_rec.attribute15,
571: p_pricing_attribs_rec.object_version_number
572: FROM csi_i_pricing_attribs
573: WHERE pricing_attribute_id = p_pricing_attrib_id;
574: RETURN TRUE;
575: END IF;
576:

Line 781: SELECT csi_i_pricing_attribs_s.nextval

777: RETURN NUMBER
778: IS
779: l_pricing_attrib_id NUMBER;
780: BEGIN
781: SELECT csi_i_pricing_attribs_s.nextval
782: INTO l_pricing_attrib_id
783: FROM dual;
784: RETURN l_pricing_attrib_id ;
785: EXCEPTION

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