APPS.OZF_OFFERADJ_APPROVAL_PVT dependencies on QP_LIST_HEADERS

Line 83: from qp_list_headers a,

79: a.end_date_active,
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

Line 255: from qp_list_headers a,

251: a.end_date_active,
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

Line 428: from qp_list_headers a,

424: a.end_date_active,
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

Line 604: from qp_list_headers a,

600: a.end_date_active,
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

Line 778: from qp_list_headers a,

774: a.end_date_active,
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

Line 978: qp_list_headers_vl qlh

974: qlh.end_date_active ,
975: OFF.transaction_currency_code ,
976: OFF.owner_id
977: FROM ozf_offers OFF,
978: qp_list_headers_vl qlh
979: WHERE OFF.qp_list_header_id=qlh.list_header_id
980: AND qlh.list_header_id=p_list_header_id;
981:
982: CURSOR c_get_budget_detail(p_list_header_id NUMBER) IS