APPS.OZF_OFFERADJ_APPROVAL_PVT dependencies on OZF_OFFER_ADJUSTMENTS_B

Line 1280: FROM ozf_offer_adjustments_b

1276: l_effective_date DATE;
1277:
1278: CURSOR c_effective_date(p_offer_adjustment_id IN NUMBER) IS
1279: SELECT effective_date
1280: FROM ozf_offer_adjustments_b
1281: WHERE offer_adjustment_id = p_offer_adjustment_id ;
1282:
1283: l_user_id NUMBER;
1284: l_resp_id NUMBER;

Line 1390: UPDATE ozf_offer_adjustments_b

1386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1387: END IF;
1388: else
1389: -- for rejected or some other status update the status to next status code
1390: UPDATE ozf_offer_adjustments_b
1391: SET status_code = l_next_status_code ,
1392: -- approved_date = sysdate ,
1393: object_version_number = l_object_version_number+1
1394: WHERE offer_adjustment_id = l_offer_adjustment_id;