DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_PRICING_PVT dependencies on OKL_CASH_FLOW_LEVELS

Line 2663: FROM OKL_CASH_FLOW_LEVELS

2659:
2660: CURSOR check_stub(l_cashflow_id NUMBER) IS
2661: SELECT STUB_DAYS,
2662: STUB_AMOUNT
2663: FROM OKL_CASH_FLOW_LEVELS
2664: WHERE CAF_ID = l_cashflow_id;
2665:
2666: CURSOR get_periods(l_cashflow_id NUMBER) IS
2667: SELECT SUM(NUMBER_OF_PERIODS)

Line 2668: FROM OKL_CASH_FLOW_LEVELS

2664: WHERE CAF_ID = l_cashflow_id;
2665:
2666: CURSOR get_periods(l_cashflow_id NUMBER) IS
2667: SELECT SUM(NUMBER_OF_PERIODS)
2668: FROM OKL_CASH_FLOW_LEVELS
2669: WHERE CAF_ID = l_cashflow_id;
2670:
2671: l_stub_days NUMBER;
2672: l_stub_amount NUMBER;

Line 2735: FROM OKL_CASH_FLOW_LEVELS

2731:
2732: CURSOR check_stub(l_cashflow_id NUMBER) IS
2733: SELECT STUB_DAYS,
2734: STUB_AMOUNT
2735: FROM OKL_CASH_FLOW_LEVELS
2736: WHERE CAF_ID = l_cashflow_id;
2737:
2738: CURSOR check_count(l_cashflow_id NUMBER) IS
2739: SELECT COUNT(ID)

Line 2740: FROM OKL_CASH_FLOW_LEVELS

2736: WHERE CAF_ID = l_cashflow_id;
2737:
2738: CURSOR check_count(l_cashflow_id NUMBER) IS
2739: SELECT COUNT(ID)
2740: FROM OKL_CASH_FLOW_LEVELS
2741: WHERE CAF_ID = l_cashflow_id;
2742:
2743: CURSOR get_amount(l_cashflow_id NUMBER) IS
2744: SELECT AMOUNT

Line 2745: FROM OKL_CASH_FLOW_LEVELS

2741: WHERE CAF_ID = l_cashflow_id;
2742:
2743: CURSOR get_amount(l_cashflow_id NUMBER) IS
2744: SELECT AMOUNT
2745: FROM OKL_CASH_FLOW_LEVELS
2746: WHERE CAF_ID = l_cashflow_id;
2747:
2748: l_stub_days NUMBER;
2749: l_stub_amount NUMBER;