81: b.effective_date,
82: b.offer_adjustment_name
83: from qp_list_headers a,
84: ozf_offer_adjustments_vl b,
85: ozf_lookups lkp,
86: ozf_lookups lkp1,
87: ozf_offers offr
88: where a.list_header_id = b.list_header_id
89: and a.list_header_id = offr.qp_list_header_id
82: b.offer_adjustment_name
83: from qp_list_headers a,
84: ozf_offer_adjustments_vl b,
85: ozf_lookups lkp,
86: ozf_lookups lkp1,
87: ozf_offers offr
88: where a.list_header_id = b.list_header_id
89: and a.list_header_id = offr.qp_list_header_id
90: and b.offer_adjustment_id = p_offer_adjustment_id
253: b.effective_date,
254: b.offer_adjustment_name
255: from qp_list_headers a,
256: ozf_offer_adjustments_vl b,
257: ozf_lookups lkp,
258: ozf_lookups lkp1,
259: ozf_offers offr
260: where a.list_header_id = b.list_header_id
261: and a.list_header_id = offr.qp_list_header_id
254: b.offer_adjustment_name
255: from qp_list_headers a,
256: ozf_offer_adjustments_vl b,
257: ozf_lookups lkp,
258: ozf_lookups lkp1,
259: ozf_offers offr
260: where a.list_header_id = b.list_header_id
261: and a.list_header_id = offr.qp_list_header_id
262: and b.offer_adjustment_id = p_offer_adjustment_id
426: b.effective_date,
427: b.offer_adjustment_name
428: from qp_list_headers a,
429: ozf_offer_adjustments_vl b,
430: ozf_lookups lkp,
431: ozf_lookups lkp1,
432: ozf_offers offr
433: where a.list_header_id = b.list_header_id
434: and a.list_header_id = offr.qp_list_header_id
427: b.offer_adjustment_name
428: from qp_list_headers a,
429: ozf_offer_adjustments_vl b,
430: ozf_lookups lkp,
431: ozf_lookups lkp1,
432: ozf_offers offr
433: where a.list_header_id = b.list_header_id
434: and a.list_header_id = offr.qp_list_header_id
435: and b.offer_adjustment_id = p_offer_adjustment_id
602: b.effective_date,
603: b.offer_adjustment_name
604: from qp_list_headers a,
605: ozf_offer_adjustments_vl b,
606: ozf_lookups lkp,
607: ozf_lookups lkp1,
608: ozf_offers offr
609: where a.list_header_id = b.list_header_id
610: and a.list_header_id = offr.qp_list_header_id
603: b.offer_adjustment_name
604: from qp_list_headers a,
605: ozf_offer_adjustments_vl b,
606: ozf_lookups lkp,
607: ozf_lookups lkp1,
608: ozf_offers offr
609: where a.list_header_id = b.list_header_id
610: and a.list_header_id = offr.qp_list_header_id
611: and b.offer_adjustment_id = p_offer_adjustment_id
776: b.effective_date,
777: b.offer_adjustment_name
778: from qp_list_headers a,
779: ozf_offer_adjustments_vl b,
780: ozf_lookups lkp,
781: ozf_lookups lkp1,
782: ozf_offers offr
783: where a.list_header_id = b.list_header_id
784: and a.list_header_id = offr.qp_list_header_id
777: b.offer_adjustment_name
778: from qp_list_headers a,
779: ozf_offer_adjustments_vl b,
780: ozf_lookups lkp,
781: ozf_lookups lkp1,
782: ozf_offers offr
783: where a.list_header_id = b.list_header_id
784: and a.list_header_id = offr.qp_list_header_id
785: and b.offer_adjustment_id = p_offer_adjustment_id