APPS.OZF_OFFERADJ_APPROVAL_PVT dependencies on OZF_OFFERS

Line 86: ozf_offers offr

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
88: and a.list_header_id = offr.qp_list_header_id
89: and b.offer_adjustment_id = p_offer_adjustment_id
90: and lkp.lookup_code = b.settlement_code

Line 258: ozf_offers offr

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
260: and a.list_header_id = offr.qp_list_header_id
261: and b.offer_adjustment_id = p_offer_adjustment_id
262: and lkp.lookup_code = b.settlement_code

Line 431: ozf_offers offr

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
433: and a.list_header_id = offr.qp_list_header_id
434: and b.offer_adjustment_id = p_offer_adjustment_id
435: and lkp.lookup_code = b.settlement_code

Line 607: ozf_offers offr

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
609: and a.list_header_id = offr.qp_list_header_id
610: and b.offer_adjustment_id = p_offer_adjustment_id
611: and lkp.lookup_code = b.settlement_code

Line 781: ozf_offers offr

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
783: and a.list_header_id = offr.qp_list_header_id
784: and b.offer_adjustment_id = p_offer_adjustment_id
785: and lkp.lookup_code = b.settlement_code

Line 976: FROM ozf_offers OFF,

972: qlh.start_date_active,
973: qlh.end_date_active ,
974: OFF.transaction_currency_code ,
975: OFF.owner_id
976: FROM ozf_offers OFF,
977: qp_list_headers_vl qlh
978: WHERE OFF.qp_list_header_id=qlh.list_header_id
979: AND qlh.list_header_id=p_list_header_id;
980:

Line 992: FROM ozf_funds_all_vl fund, ozf_offers offr

988: fund.start_date_active,
989: fund.end_date_active,
990: fund.currency_code_tc,
991: fund.owner
992: FROM ozf_funds_all_vl fund, ozf_offers offr
993: WHERE fund.fund_number = offr.offer_code
994: AND offr.qp_list_header_id = p_list_header_id;
995:
996:

Line 1000: FROM ozf_offers

996:
997:
998: CURSOR c_budget_offer_yn(p_list_header_id NUMBER) IS
999: SELECT NVL(budget_offer_yn, 'N')
1000: FROM ozf_offers
1001: WHERE qp_list_header_id = p_list_header_id;
1002:
1003: l_budget_offer_yn VARCHAR2(1);
1004: