APPS.OZF_FUND_RECONCILE_PVT dependencies on OZF_REQUEST_HEADERS_ALL_B

Line 259: FROM ozf_offers off,ozf_request_headers_all_b req

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

Line 274: FROM ozf_offers off,ozf_request_headers_all_b req

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

Line 558: UPDATE ozf_request_headers_all_b

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

Line 565: UPDATE ozf_request_headers_all_b

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