APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on OZF_OFFERS

Line 1511: FROM ozf_offers ozf,

1507: qp.orig_org_id,
1508: qp_tl.description offer_name,
1509: ozf.sales_method_flag,
1510: NVL(ozf.resale_line_id_processed, 0) resale_line_id_processed
1511: FROM ozf_offers ozf,
1512: qp_list_headers_all_b qp,
1513: qp_list_headers_tl qp_tl
1514: WHERE ozf.offer_type = 'NET_ACCRUAL'
1515: AND ozf.status_code = 'ACTIVE'

Line 1902: ozf_offers b,

1898: a.adjustment_date conv_date,
1899: a.currency_code,
1900: a.org_id --Added for bug 7030415
1901: FROM ozf_funds_utilized_all_b a,
1902: ozf_offers b,
1903: ozf_na_products_temp c
1904: WHERE a.plan_type = 'OFFR'
1905: AND a.plan_id = b.qp_list_header_id
1906: AND b.qp_list_header_id <> p_qp_list_header_id

Line 1929: -- ozf_offers b,

1925: -- a.reference_type,
1926: -- a.reference_id,
1927: -- a.org_id --Added for bug 7030415
1928: -- FROM ozf_funds_utilized_all_b a,
1929: -- ozf_offers b,
1930: -- ozf_na_products_temp c
1931: -- WHERE a.plan_type = 'OFFR'
1932: -- AND a.plan_id = b.qp_list_header_id
1933: -- AND b.qp_list_header_id <> p_qp_list_header_id

Line 1956: ozf_offers b,

1952: a.reference_type,
1953: a.reference_id,
1954: a.org_id --Added for bug 7030415
1955: FROM ozf_funds_utilized_all_b a,
1956: ozf_offers b,
1957: ozf_na_products_temp c
1958: WHERE a.plan_type = 'OFFR'
1959: AND a.plan_id = b.qp_list_header_id
1960: AND b.qp_list_header_id <> p_qp_list_header_id

Line 4175: UPDATE ozf_offers

4171: ozf_utility_pvt.write_conc_log('-- Done Processing Deduction Rules -- ');
4172: ozf_utility_pvt.write_conc_log('--------------------------------------');
4173:
4174: 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
4175: UPDATE ozf_offers
4176: SET latest_na_completion_date = l_as_of_date
4177: WHERE offer_id = l_net_accrual_offers.offer_id;
4178: END IF;
4179:

Line 4618: UPDATE ozf_offers

4614: END IF; -- end l_accrual_amount <> 0
4615: --
4616: END IF; -- end l_batch_mode = 'YES'
4617:
4618: UPDATE ozf_offers
4619: SET resale_line_id_processed = l_idsm_line_processed
4620: WHERE offer_id = l_net_accrual_offers.offer_id;
4621: --
4622: END IF; -- End IDSM lines

Line 4736: FROM ozf_offers

4732: SELECT offer_type,
4733: tier_level,
4734: qp_list_header_id,
4735: custom_setup_id
4736: FROM ozf_offers
4737: WHERE offer_id = p_offer_id;
4738:
4739: CURSOR c_order_line_detail1 IS
4740: SELECT a.*

Line 4842: FROM ozf_offers

4838: l_sold_to_org_id_tbl number_tbl_type;
4839:
4840: CURSOR c_offer_type IS
4841: SELECT offer_type, tier_level, qp_list_header_id, custom_setup_id
4842: FROM ozf_offers
4843: WHERE offer_id = p_offer_id;
4844:
4845: CURSOR c_order_line IS
4846: SELECT a.header_id,