APPS.QP_DENORMALIZED_PRICING_ATTRS dependencies on QP_FACTOR_LIST_ATTRS

Line 251: DELETE FROM qp_factor_list_attrs

247: );
248: END IF; --If stmt to check values of parameters p_list_header_id_low and high
249:
250:
251: DELETE FROM qp_factor_list_attrs
252: WHERE list_header_id BETWEEN l_list_header_id_low AND l_list_header_id_high;
253:
254:
255: INSERT INTO qp_factor_list_attrs

Line 255: INSERT INTO qp_factor_list_attrs

251: DELETE FROM qp_factor_list_attrs
252: WHERE list_header_id BETWEEN l_list_header_id_low AND l_list_header_id_high;
253:
254:
255: INSERT INTO qp_factor_list_attrs
256: (SELECT DISTINCT a.list_header_id,
257: a.pricing_attribute_context, a.pricing_attribute
258: FROM qp_pricing_attributes a, qp_list_headers_b b
259: WHERE a.list_header_id = b.list_header_id