DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_PRICING_PVT dependencies on OKL_CASH_FLOW_OBJECTS

Line 1139: FROM OKL_CASH_FLOW_OBJECTS

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

Line 1792: FROM OKL_CASH_FLOW_OBJECTS

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

Line 1800: FROM OKL_CASH_FLOW_OBJECTS

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

Line 2454: l_source_object_code okl_cash_flow_objects.OTY_CODE%TYPE;

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

Line 2455: l_source_object_id okl_cash_flow_objects.SOURCE_ID%TYPE;

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

Line 2468: FROM OKL_CASH_FLOW_OBJECTS

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