DBA Data[Home] [Help]

APPS.OKL_SALES_QUOTE_QA_PVT dependencies on OKL_FEES_V

Line 13: select * from okl_fees_v ofv

9: AND LANGUAGE_CODE = USERENV('LANG');
10:
11:
12: CURSOR c_lq_fee_rec(p_parent_object_id NUMBER,p_fee_type VARCHAR2) IS
13: select * from okl_fees_v ofv
14: WHERE ofv.parent_object_id=p_parent_object_id
15: AND ofv.fee_type=p_fee_type;
16:
17: CURSOR c_lq_cfl_line(p_source_id NUMBER,p_oty_code VARCHAR2) IS

Line 3039: from okl_fees_v ofv

3035: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
3036: --Fetch all the Configuration Fees For Quote
3037: cursor c_config_fee_rec(p_quote_id NUMBER) IS
3038: select ofv.*
3039: from okl_fees_v ofv
3040: where ofv.parent_object_code='LEASEQUOTE'
3041: AND ofv.parent_object_id=p_quote_id
3042: AND ofv.fee_type IN ('FINANCED','ROLLOVER');
3043: