DBA Data[Home] [Help]

APPS.AMS_SCHEDULERULES_PVT dependencies on OZF_ACT_OFFERS

Line 4474: OZF_ACT_OFFERS ACT_OFFER,

4470:
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