APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on OZF_OFFERS

Line 1413: FROM ozf_offers ozf,

1409: qp.orig_org_id,
1410: qp_tl.description offer_name,
1411: ozf.sales_method_flag,
1412: NVL(ozf.resale_line_id_processed, 0) resale_line_id_processed
1413: FROM ozf_offers ozf,
1414: qp_list_headers_b qp,
1415: qp_list_headers_tl qp_tl
1416: WHERE ozf.offer_type = 'NET_ACCRUAL'
1417: AND ozf.status_code = 'ACTIVE'

Line 1602: ozf_offers b,

1598: a.adjustment_date conv_date,
1599: a.currency_code,
1600: a.org_id --Added for bug 7030415
1601: FROM ozf_funds_utilized_all_b a,
1602: ozf_offers b,
1603: ozf_na_products_temp c
1604: WHERE a.plan_type = 'OFFR'
1605: AND a.plan_id = b.qp_list_header_id
1606: AND b.qp_list_header_id <> p_qp_list_header_id

Line 3079: UPDATE ozf_offers

3075: ozf_utility_pvt.write_conc_log('-- Done Processing Deduction Rules -- ');
3076: ozf_utility_pvt.write_conc_log('--------------------------------------');
3077:
3078: IF l_net_accrual_offers.latest_na_completion_date IS NULL OR l_net_accrual_offers.latest_na_completion_date < l_as_of_date THEN
3079: UPDATE ozf_offers
3080: SET latest_na_completion_date = l_as_of_date
3081: WHERE offer_id = l_net_accrual_offers.offer_id;
3082: END IF;
3083:

Line 3480: UPDATE ozf_offers

3476: END IF; -- end l_accrual_amount <> 0
3477: --
3478: END IF; -- end l_batch_mode = 'YES'
3479:
3480: UPDATE ozf_offers
3481: SET resale_line_id_processed = l_idsm_line_processed
3482: WHERE offer_id = l_net_accrual_offers.offer_id;
3483: --
3484: END IF; -- End IDSM lines

Line 3560: FROM ozf_offers

3556: SELECT offer_type,
3557: tier_level,
3558: qp_list_header_id,
3559: custom_setup_id
3560: FROM ozf_offers
3561: WHERE offer_id = p_offer_id;
3562:
3563: CURSOR c_order_line_detail1 IS
3564: SELECT a.*

Line 3666: FROM ozf_offers

3662: l_sold_to_org_id_tbl number_tbl_type;
3663:
3664: CURSOR c_offer_type IS
3665: SELECT offer_type, tier_level, qp_list_header_id, custom_setup_id
3666: FROM ozf_offers
3667: WHERE offer_id = p_offer_id;
3668:
3669: CURSOR c_order_line IS
3670: SELECT a.header_id,