DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_PRICING_PVT dependencies on OKL_CASH_FLOW_LEVELS

Line 2661: FROM OKL_CASH_FLOW_LEVELS

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

Line 2666: FROM OKL_CASH_FLOW_LEVELS

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

Line 2733: FROM OKL_CASH_FLOW_LEVELS

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

Line 2738: FROM OKL_CASH_FLOW_LEVELS

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

Line 2743: FROM OKL_CASH_FLOW_LEVELS

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