APPS.OZF_ACCRUAL_ENGINE dependencies on OZF_OFFERS

Line 177: FROM ozf_offers

173:
174: -- cursor for accrual budget
175: CURSOR c_offer_info IS
176: SELECT NVL(budget_offer_yn,'N')
177: FROM ozf_offers
178: WHERE qp_list_header_id = p_src_id;
179: -- cursor for accrual fund
180: CURSOR c_fund IS
181: SELECT fund_id , currency_code_tc

Line 815: FROM ozf_offers

811:
812: CURSOR c_offer_type (p_offer_id IN NUMBER) IS
813: SELECT offer_type, custom_setup_id, beneficiary_account_id, transaction_currency_code,offer_id
814: ,autopay_party_attr,autopay_party_id --nirprasa
815: FROM ozf_offers
816: WHERE qp_list_header_id = p_offer_id;
817:
818: CURSOR c_accrual_flag (p_price_adjustment_id IN NUMBER) IS
819: SELECT NVL(accrual_flag,'N')

Line 2016: FROM ozf_offers

2012:
2013: CURSOR c_offer_type (p_offer_id IN NUMBER) IS
2014: SELECT beneficiary_account_id,
2015: autopay_party_attr,autopay_party_id
2016: FROM ozf_offers
2017: WHERE qp_list_header_id = p_offer_id;
2018:
2019: --Added for bug 7030415, get conversion type
2020: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS

Line 2402: FROM ozf_offers

2398: WHERE utilization_id = p_utilization_id;
2399:
2400: CURSOR c_tm_offer (p_list_header_id IN NUMBER) IS
2401: SELECT nvl(transaction_currency_code,fund_request_curr_code) transaction_currency_code
2402: FROM ozf_offers
2403: WHERE qp_list_header_id = p_list_header_id;
2404:
2405: CURSOR c_get_util (p_list_header_id IN NUMBER, p_header_id IN NUMBER, p_line_id IN NUMBER) IS
2406: SELECT 1

Line 3095: FROM ozf_offers

3091:
3092: --kdass bug 5953774
3093: CURSOR c_offer_currency (p_list_header_id IN NUMBER) IS
3094: SELECT nvl(transaction_currency_code, fund_request_curr_code) offer_currency
3095: FROM ozf_offers
3096: WHERE qp_list_header_id = p_list_header_id;
3097:
3098:
3099:

Line 3146: FROM ozf_offers

3142: WHERE order_line_id = p_line_id;
3143:
3144: CURSOR c_offer_type (p_offer_id IN NUMBER) IS
3145: SELECT offer_type
3146: FROM ozf_offers
3147: WHERE qp_list_header_id = p_offer_id;
3148:
3149: CURSOR c_discount_header(p_discount_line_id IN NUMBER) IS
3150: SELECT discount_type,volume_type