APPS.OZF_OFFERADJ_APPROVAL_PVT dependencies on OZF_OFFER_ADJUSTMENTS_B

Line 1279: FROM ozf_offer_adjustments_b

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

Line 1389: UPDATE ozf_offer_adjustments_b

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