DBA Data[Home] [Help]

APPS.AMS_SCHEDULERULES_PVT dependencies on OZF_OFFERS

Line 4505: ozf_offers off

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
4509: AND off.qp_list_header_id = ACT_OFFER.qp_list_header_id