DBA Data[Home] [Help]

APPS.AMS_SCHEDULERULES_PVT dependencies on OZF_ACT_OFFERS

Line 4504: OZF_ACT_OFFERS ACT_OFFER,

4500:
4501: CURSOR c_sch_det_offer(p_schedule_id NUMBER) IS -- anchaudh added this for bug#4957178.
4502: select offer_id
4503: from
4504: OZF_ACT_OFFERS ACT_OFFER,
4505: ozf_offers off
4506: where
4507: ACT_OFFER.ARC_ACT_OFFER_USED_BY = 'CSCH'
4508: AND ACT_OFFER.act_offer_used_by_id = p_schedule_id