APPS.OKL_SALES_QUOTE_QA_PVT dependencies on OKL_CASH_FLOWS

Line 19: FROM OKL_CASH_FLOW_OBJECTS CFO,OKL_CASH_FLOWS CAF,

15: AND ofv.fee_type=p_fee_type;
16:
17: CURSOR c_lq_cfl_line(p_source_id NUMBER,p_oty_code VARCHAR2) IS
18: SELECT CFL.*
19: FROM OKL_CASH_FLOW_OBJECTS CFO,OKL_CASH_FLOWS CAF,
20: OKL_CASH_FLOW_LEVELS CFL
21: WHERE CFO.ID=CAF.CFO_ID
22: AND CAF.ID=CFL.CAF_ID
23: AND CFO.oty_code=p_oty_code

Line 718: FROM OKL_CASH_FLOW_OBJECTS CFO,OKL_CASH_FLOWS CAF

714: CAF.ID CAF_ID,
715: CAF.STY_ID,
716: CAF.cft_code,
717: CAF.due_arrears_yn
718: FROM OKL_CASH_FLOW_OBJECTS CFO,OKL_CASH_FLOWS CAF
719: WHERE CAF.cfo_id = CFO.ID
720: AND CFO.OTY_CODE = p_oty_code
721: AND CFO.SOURCE_ID = p_quote_id;
722:

Line 729: FROM OKL_CASH_FLOW_OBJECTS CFO,OKL_CASH_FLOWS CAF,

725: CFL.amount,
726: CFL.number_of_periods,
727: CFL.stub_days,
728: CFL.stub_amount
729: FROM OKL_CASH_FLOW_OBJECTS CFO,OKL_CASH_FLOWS CAF,
730: OKL_CASH_FLOW_LEVELS CFL
731: WHERE CFO.ID=CAF.CFO_ID
732: AND CAF.ID=CFL.CAF_ID
733: AND CFO.oty_code=p_oty_code

Line 3319: FROM OKL_CASH_FLOWS CAF,OKL_CASH_FLOW_LEVELS CFL

3315: AND oab.parent_object_id=p_quote_id;
3316:
3317: CURSOR c_payment_level_rec(p_quote_id NUMBER) IS
3318: SELECT TRUNC(CFL.start_date)
3319: FROM OKL_CASH_FLOWS CAF,OKL_CASH_FLOW_LEVELS CFL
3320: WHERE CAF.ID=CFL.CAF_ID
3321: AND CAF.dnz_qte_id=p_quote_id;
3322: ---Check the Date Condition
3323: CURSOR c_vp_rec(p_vp_id NUMBER,p_contract_start_date DATE) IS

Line 3349: FROM OKL_CASH_FLOW_OBJECTS CFO,OKL_CASH_FLOWS CAF,

3345:
3346: --Get the Cash Flow Count for Quote/Asset/Config Fees
3347: CURSOR c_cash_flow_level_count(p_source_id NUMBER,p_oty_code VARCHAR2) IS
3348: SELECT count(*) cfl_count
3349: FROM OKL_CASH_FLOW_OBJECTS CFO,OKL_CASH_FLOWS CAF,
3350: OKL_CASH_FLOW_LEVELS CFL
3351: WHERE CFO.ID=CAF.CFO_ID
3352: AND CAF.ID=CFL.CAF_ID
3353: AND CFO.oty_code=p_oty_code