DBA Data[Home] [Help]

APPS.AMS_SCHEDULERULES_PVT dependencies on OZF_OFFERS

Line 4475: ozf_offers off

4471: CURSOR c_sch_det_offer(p_schedule_id NUMBER) IS -- anchaudh added this for bug#4957178.
4472: select offer_id
4473: from
4474: OZF_ACT_OFFERS ACT_OFFER,
4475: ozf_offers off
4476: where
4477: ACT_OFFER.ARC_ACT_OFFER_USED_BY = 'CSCH'
4478: AND ACT_OFFER.act_offer_used_by_id = p_schedule_id
4479: AND off.qp_list_header_id = ACT_OFFER.qp_list_header_id