DBA Data[Home] [Help]

APPS.OZF_CLAIM_APPROVAL_PVT dependencies on OZF_OFFERS

Line 223: FROM ozf_offers o

219: l_offer_name VARCHAR2(30);
220:
221: CURSOR csr_offer_name(cv_offer_id IN NUMBER) IS
222: SELECT o.offer_code
223: FROM ozf_offers o
224: WHERE o.qp_list_header_id = cv_offer_id;
225:
226: BEGIN
227: OZF_Claim_Accrual_PVT.Check_Offer_Performance_Tbl(

Line 257: FROM ozf_offers o

253: l_offer_name VARCHAR2(30);
254:
255: CURSOR csr_offer_name(cv_offer_id IN NUMBER) IS
256: SELECT o.offer_code
257: FROM ozf_offers o
258: WHERE o.qp_list_header_id = cv_offer_id;
259:
260: BEGIN
261: OZF_Claim_Accrual_PVT.Check_Offer_Earning_Tbl(