APPS.OZF_OFFERADJ_APPROVAL_PVT dependencies on OZF_OFFER_ADJUSTMENTS_VL

Line 83: ozf_offer_adjustments_vl b,

79: lkp.meaning settlement_name,
80: b.effective_date,
81: b.offer_adjustment_name
82: from qp_list_headers a,
83: ozf_offer_adjustments_vl b,
84: ozf_lookups lkp,
85: ozf_lookups lkp1,
86: ozf_offers offr
87: where a.list_header_id = b.list_header_id

Line 255: ozf_offer_adjustments_vl b,

251: lkp.meaning settlement_name,
252: b.effective_date,
253: b.offer_adjustment_name
254: from qp_list_headers a,
255: ozf_offer_adjustments_vl b,
256: ozf_lookups lkp,
257: ozf_lookups lkp1,
258: ozf_offers offr
259: where a.list_header_id = b.list_header_id

Line 428: ozf_offer_adjustments_vl b,

424: lkp.meaning settlement_name,
425: b.effective_date,
426: b.offer_adjustment_name
427: from qp_list_headers a,
428: ozf_offer_adjustments_vl b,
429: ozf_lookups lkp,
430: ozf_lookups lkp1,
431: ozf_offers offr
432: where a.list_header_id = b.list_header_id

Line 604: ozf_offer_adjustments_vl b,

600: lkp.meaning settlement_name,
601: b.effective_date,
602: b.offer_adjustment_name
603: from qp_list_headers a,
604: ozf_offer_adjustments_vl b,
605: ozf_lookups lkp,
606: ozf_lookups lkp1,
607: ozf_offers offr
608: where a.list_header_id = b.list_header_id

Line 778: ozf_offer_adjustments_vl b,

774: lkp.meaning settlement_name,
775: b.effective_date,
776: b.offer_adjustment_name
777: from qp_list_headers a,
778: ozf_offer_adjustments_vl b,
779: ozf_lookups lkp,
780: ozf_lookups lkp1,
781: ozf_offers offr
782: where a.list_header_id = b.list_header_id

Line 959: from ozf_offer_adjustments_vl

955: description,
956: effective_date,
957: list_header_id,
958: offer_adjustment_name
959: from ozf_offer_adjustments_vl
960: where offer_adjustment_id = p_offer_adjustment_id;
961:
962: -- changed budget_amount to use budget_amount_tc from the hardcoded 0, so that approval rules with a range would work.
963: CURSOR c_get_activity_details(p_list_header_id IN NUMBER) IS