APPS.OZF_OFFERADJ_APPROVAL_PVT dependencies on OZF_OFFERS

Line 87: ozf_offers offr

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
91: and lkp.lookup_code = b.settlement_code

Line 259: ozf_offers offr

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
263: and lkp.lookup_code = b.settlement_code

Line 432: ozf_offers offr

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
436: and lkp.lookup_code = b.settlement_code

Line 608: ozf_offers offr

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
612: and lkp.lookup_code = b.settlement_code

Line 782: ozf_offers offr

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
786: and lkp.lookup_code = b.settlement_code

Line 977: FROM ozf_offers OFF,

973: qlh.start_date_active,
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:

Line 993: FROM ozf_funds_all_vl fund, ozf_offers offr

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

Line 1001: FROM ozf_offers

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