APPS.OZF_OFFER_ADJ_PVT dependencies on QP_LIST_HEADERS_B

Line 129: ,qp_list_headers_b h

125: INTO l_headerStDt
126: ,l_lineStDt
127: ,l_effectiveDt
128: FROM ozf_offer_adjustments_b a
129: ,qp_list_headers_b h
130: ,qp_list_lines l
131: WHERE a.list_header_id = h.list_header_id
132: and a.list_header_id = l.list_header_id
133: and l.list_line_id = p_listLineId

Line 2113: , qp_list_headers_b h

2109: , a.discount_end_date
2110: , h.start_date_active
2111: FROM ozf_offer_adjustment_lines a
2112: , ozf_offer_adjustments_b b
2113: , qp_list_headers_b h
2114: WHERE a.offer_adjustment_id = b.offer_adjustment_id
2115: AND a.list_header_id = h.list_header_id
2116: AND a.list_header_id = a.list_header_id
2117: AND a.offer_adjustment_id = cp_offerAdjustmentId

Line 2178: , qp_list_headers_b d

2174: FROM
2175: qp_list_lines a
2176: , ozf_related_deal_lines b
2177: , qp_list_lines c
2178: , qp_list_headers_b d
2179: WHERE
2180: a.list_line_id = b.modifier_id
2181: AND b.related_modifier_id = c.list_line_id(+)
2182: AND a.list_header_id = d.list_header_id

Line 4663: FROM ozf_offer_adjustments_b a, qp_list_headers_b b , ozf_offers c

4659: CURSOR c_dates(cp_offerAdjustmentId NUMBER) IS
4660: SELECT a.effective_date , b.start_date_active , a.list_header_id
4661: ,c.offer_type , c.object_version_number
4662: ,c.custom_setup_id
4663: FROM ozf_offer_adjustments_b a, qp_list_headers_b b , ozf_offers c
4664: WHERE a.list_header_id = b.list_header_id
4665: AND b.list_header_id = c.qp_list_header_id
4666: AND a.offer_adjustment_id = cp_offerAdjustmentId ;
4667: