80: lkp.meaning settlement_name,
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
252: lkp.meaning settlement_name,
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
425: lkp.meaning settlement_name,
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
601: lkp.meaning settlement_name,
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
775: lkp.meaning settlement_name,
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
956: description,
957: effective_date,
958: list_header_id,
959: offer_adjustment_name
960: from ozf_offer_adjustments_vl
961: where offer_adjustment_id = p_offer_adjustment_id;
962:
963: -- changed budget_amount to use budget_amount_tc from the hardcoded 0, so that approval rules with a range would work.
964: CURSOR c_get_activity_details(p_list_header_id IN NUMBER) IS