APPS.OZF_FUND_RECONCILE_PVT dependencies on OZF_REQUEST_HEADERS_ALL_B

Line 262: FROM ozf_offers off,ozf_request_headers_all_b req

258: p_code IN VARCHAR2,
259: p_end_date IN DATE) IS
260: SELECT qp_list_header_id object_id
261: ,nvl(transaction_currency_code,fund_request_curr_code) object_curr
262: FROM ozf_offers off,ozf_request_headers_all_b req
263: WHERE off.qp_list_header_id = req.offer_id
264: AND req.request_class ='SOFT_FUND'
265: AND NVL (req.approved_date, p_grace_date) <= p_grace_date
266: AND req.status_code ='APPROVED'

Line 277: FROM ozf_offers off,ozf_request_headers_all_b req

273: p_code IN VARCHAR2,
274: p_end_date IN DATE) IS
275: SELECT qp_list_header_id object_id
276: ,nvl(transaction_currency_code,fund_request_curr_code) object_curr
277: FROM ozf_offers off,ozf_request_headers_all_b req
278: WHERE off.qp_list_header_id = req.offer_id
279: AND req.request_class ='SPECIAL_PRICE'
280: AND NVL (req.end_date, p_grace_date) <= p_grace_date
281: AND req.status_code ='APPROVED'

Line 561: UPDATE ozf_request_headers_all_b

557: ELSIF p_object_type = 'SOFT_FUND' THEN
558: UPDATE ozf_offers
559: SET account_closed_flag = 'Y'
560: WHERE qp_list_header_id = l_object_tbl (k).object_id;
561: UPDATE ozf_request_headers_all_b
562: SET status_code = 'CLOSED'
563: WHERE offer_id = l_object_tbl (k).object_id;
564: ELSIF p_object_type = 'SPECIAL_PRICE' THEN
565: UPDATE ozf_offers

Line 568: UPDATE ozf_request_headers_all_b

564: ELSIF p_object_type = 'SPECIAL_PRICE' THEN
565: UPDATE ozf_offers
566: SET account_closed_flag = 'Y'
567: WHERE qp_list_header_id = l_object_tbl (k).object_id;
568: UPDATE ozf_request_headers_all_b
569: SET status_code = 'CLOSED'
570: WHERE offer_id = l_object_tbl (k).object_id;
571: END IF;
572: