DBA Data[Home] [Help]

APPS.OZF_OFFERADJ_APPROVAL_PVT dependencies on OZF_LOOKUPS

Line 85: ozf_lookups lkp,

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
89: and a.list_header_id = offr.qp_list_header_id

Line 86: ozf_lookups lkp1,

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

Line 257: ozf_lookups lkp,

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
261: and a.list_header_id = offr.qp_list_header_id

Line 258: ozf_lookups lkp1,

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

Line 430: ozf_lookups lkp,

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
434: and a.list_header_id = offr.qp_list_header_id

Line 431: ozf_lookups lkp1,

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

Line 606: ozf_lookups lkp,

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
610: and a.list_header_id = offr.qp_list_header_id

Line 607: ozf_lookups lkp1,

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

Line 780: ozf_lookups lkp,

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
784: and a.list_header_id = offr.qp_list_header_id

Line 781: ozf_lookups lkp1,

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