APPS.OZF_OFFER_ADJ_PVT dependencies on OZF_SD_REQUEST_HEADERS_ALL_B

Line 1127: FROM ozf_sd_request_headers_all_b

1123: SELECT request_header_id
1124: ,object_version_number
1125: ,trunc(request_start_date)
1126: ,trunc(request_end_date)
1127: FROM ozf_sd_request_headers_all_b
1128: WHERE offer_id = p_offer_id;
1129:
1130: CURSOR c_get_offer_hdr (p_list_header_id IN NUMBER) IS
1131: SELECT custom_setup_id

Line 3583: FROM ozf_sd_request_headers_all_b

3579: ,org_id
3580: ,request_currency_code
3581: ,trunc(request_start_date)
3582: ,trunc(request_end_date)
3583: FROM ozf_sd_request_headers_all_b
3584: WHERE offer_id = p_list_header_id;
3585:
3586: l_start_date_active DATE;
3587: l_end_date_active DATE;

Line 4713: UPDATE ozf_sd_request_headers_all_b

4709: ozf_utility_pvt.debug_message('l_dates.list_header_id'|| l_dates.list_header_id);
4710: IF l_dates.start_date_active IS NOT NULL AND l_dates.start_date_active <> FND_API.G_MISS_DATE THEN
4711: -- if effective date is before start_date of the offer update the start_date of the offer
4712: IF l_dates.effective_date < l_dates.start_date_active THEN
4713: UPDATE ozf_sd_request_headers_all_b
4714: SET request_start_date = l_dates.effective_date,
4715: object_version_number = object_version_number + 1
4716: WHERE offer_id = l_dates.list_header_id;
4717: END IF;