DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_PRICING_PVT dependencies on OKL_CASH_FLOW_OBJECTS

Line 1137: FROM OKL_CASH_FLOW_OBJECTS

1133:
1134: CURSOR c_check_cash_flow(p_quote_id OKL_LEASE_QUOTES_B.ID%TYPE)
1135: IS
1136: SELECT 'YES'
1137: FROM OKL_CASH_FLOW_OBJECTS
1138: WHERE OTY_CODE = 'LEASE_QUOTE'
1139: AND SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'
1140: AND SOURCE_ID = p_quote_id;
1141:

Line 1790: FROM OKL_CASH_FLOW_OBJECTS

1786:
1787: CURSOR c_check_asset_cash_flow(p_asset_id OKL_ASSETS_B.ID%TYPE)
1788: IS
1789: SELECT 'YES'
1790: FROM OKL_CASH_FLOW_OBJECTS
1791: WHERE OTY_CODE = 'QUOTED_ASSET'
1792: AND SOURCE_TABLE = 'OKL_ASSETS_B'
1793: AND SOURCE_ID = p_asset_id;
1794:

Line 1798: FROM OKL_CASH_FLOW_OBJECTS

1794:
1795: CURSOR c_check_fee_cash_flow(p_fee_id OKL_FEES_B.ID%TYPE)
1796: IS
1797: SELECT 'YES'
1798: FROM OKL_CASH_FLOW_OBJECTS
1799: WHERE OTY_CODE = 'QUOTED_FEE'
1800: AND SOURCE_TABLE = 'OKL_FEES_B'
1801: AND SOURCE_ID = p_fee_id;
1802:

Line 2452: l_source_object_code okl_cash_flow_objects.OTY_CODE%TYPE;

2448: l_debug_enabled VARCHAR2(10);
2449:
2450:
2451: -- Record/Table Type Declarations
2452: l_source_object_code okl_cash_flow_objects.OTY_CODE%TYPE;
2453: l_source_object_id okl_cash_flow_objects.SOURCE_ID%TYPE;
2454: l_lease_qte_rec lease_qte_rec_type;
2455: lx_lease_qte_rec lease_qte_rec_type;
2456: l_fee_rec fee_rec_type;

Line 2453: l_source_object_id okl_cash_flow_objects.SOURCE_ID%TYPE;

2449:
2450:
2451: -- Record/Table Type Declarations
2452: l_source_object_code okl_cash_flow_objects.OTY_CODE%TYPE;
2453: l_source_object_id okl_cash_flow_objects.SOURCE_ID%TYPE;
2454: l_lease_qte_rec lease_qte_rec_type;
2455: lx_lease_qte_rec lease_qte_rec_type;
2456: l_fee_rec fee_rec_type;
2457: lx_fee_rec fee_rec_type;

Line 2466: FROM OKL_CASH_FLOW_OBJECTS

2462:
2463: CURSOR c_check_cash_flow(p_source_id NUMBER,p_source_code VARCHAR2)
2464: IS
2465: SELECT 'YES'
2466: FROM OKL_CASH_FLOW_OBJECTS
2467: WHERE OTY_CODE = p_source_code
2468: AND SOURCE_ID = p_source_id;
2469:
2470: