APPS.OKL_LEASE_QUOTE_SUBPOOL_PVT dependencies on OKL_QUOTE_SUBPOOL_USAGE

Line 21: FROM okl_quote_subpool_usage

17: lv_obj_code VARCHAR2(30);
18:
19: CURSOR c_check_record_exists(p_obj_code IN VARCHAR2) IS
20: SELECT 'Y'
21: FROM okl_quote_subpool_usage
22: WHERE source_object_id = p_object_id
23: AND source_type_code = p_obj_code
24: AND subsidy_pool_id = p_subsidy_pool_id;
25: BEGIN

Line 279: FROM OKL_QUOTE_SUBPOOL_USAGE

275: i BINARY_INTEGER := 0;
276:
277: CURSOR c_get_quote_subpool_usage IS
278: SELECT ID
279: FROM OKL_QUOTE_SUBPOOL_USAGE
280: WHERE SUBSIDY_POOL_ID = p_subsidy_pool_id
281: AND SOURCE_OBJECT_ID = p_source_object_id;
282: BEGIN
283: FOR l_get_quote_subpool_usage IN c_get_quote_subpool_usage LOOP

Line 356: FROM OKL_QUOTE_SUBPOOL_USAGE

352: SUBSIDY_AMOUNT,
353: SUBSIDY_CURRENCY_CODE,
354: VENDOR_ID,
355: CONVERSION_RATE
356: FROM OKL_QUOTE_SUBPOOL_USAGE
357: WHERE SUBSIDY_POOL_ID = p_subsidy_pool_id
358: AND SOURCE_OBJECT_ID = p_quote_id;
359:
360: BEGIN

Line 1083: FROM OKL_QUOTE_SUBPOOL_USAGE

1079: FOR l_get_leaseopp_pool_values IN c_get_leaseopp_pool_values LOOP
1080:
1081: SELECT COUNT(*)
1082: INTO ln_count
1083: FROM OKL_QUOTE_SUBPOOL_USAGE
1084: WHERE SUBSIDY_POOL_ID = l_get_leaseopp_pool_values.subsidy_pool_id
1085: AND SOURCE_OBJECT_ID = l_get_leaseopp_pool_values.quote_id;
1086:
1087: IF (ln_count > 0) THEN -- The Subsidy pool is highest for a Quote

Line 1210: FROM OKL_QUOTE_SUBPOOL_USAGE

1206: FOR l_get_leaseopp_pool_values IN c_get_leaseopp_pool_values LOOP
1207:
1208: SELECT COUNT(*)
1209: INTO ln_count
1210: FROM OKL_QUOTE_SUBPOOL_USAGE
1211: WHERE SUBSIDY_POOL_ID = l_get_leaseopp_pool_values.subsidy_pool_id
1212: AND SOURCE_OBJECT_ID = l_get_leaseopp_pool_values.quote_id;
1213:
1214: IF (ln_count > 0) THEN -- The Subsidy pool is highest for a Quote

Line 1369: FROM OKL_QUOTE_SUBPOOL_USAGE

1365: FOR l_get_leaseapp_pool_values IN c_get_leaseapp_pool_values LOOP
1366:
1367: SELECT COUNT(*)
1368: INTO ln_count
1369: FROM OKL_QUOTE_SUBPOOL_USAGE
1370: WHERE SUBSIDY_POOL_ID = l_get_leaseapp_pool_values.subsidy_pool_id
1371: AND SOURCE_OBJECT_ID = p_leaseapp_id;
1372:
1373: IF (ln_count > 0) THEN -- The Subsidy pool is highest for a Quote

Line 1876: FROM OKL_QUOTE_SUBPOOL_USAGE

1872: SUBSIDY_AMOUNT,
1873: SUBSIDY_CURRENCY_CODE,
1874: VENDOR_ID,
1875: CONVERSION_RATE
1876: FROM OKL_QUOTE_SUBPOOL_USAGE
1877: WHERE SUBSIDY_POOL_ID = l_subsidy_pool_id
1878: AND SOURCE_OBJECT_ID = l_qte_id;
1879:
1880: ln_count NUMBER;

Line 2257: FROM OKL_QUOTE_SUBPOOL_USAGE

2253: SUBSIDY_AMOUNT,
2254: SUBSIDY_CURRENCY_CODE,
2255: VENDOR_ID,
2256: CONVERSION_RATE
2257: FROM OKL_QUOTE_SUBPOOL_USAGE
2258: WHERE SUBSIDY_POOL_ID = l_subsidy_pool_id
2259: AND SOURCE_OBJECT_ID = l_qte_id;
2260:
2261: ln_count NUMBER;

Line 2562: FROM OKL_QUOTE_SUBPOOL_USAGE

2558: SUBSIDY_AMOUNT,
2559: SUBSIDY_CURRENCY_CODE,
2560: VENDOR_ID,
2561: CONVERSION_RATE
2562: FROM OKL_QUOTE_SUBPOOL_USAGE
2563: WHERE SUBSIDY_POOL_ID = l_subsidy_pool_id
2564: AND SOURCE_OBJECT_ID = p_quote_id;
2565:
2566:

Line 2601: FROM OKL_QUOTE_SUBPOOL_USAGE

2597: --debug_proc(' l_get_quote_pool_values.subsidy_pool_id = '||l_get_quote_pool_values.subsidy_pool_id);
2598: --debug_proc(' l_get_quote_pool_values.amount = '||l_get_quote_pool_values.amount);
2599: SELECT COUNT(*) -- Check if the Subsidy pool exists in the usage table
2600: INTO ln_count
2601: FROM OKL_QUOTE_SUBPOOL_USAGE
2602: WHERE SUBSIDY_POOL_ID = l_get_quote_pool_values.subsidy_pool_id
2603: AND SOURCE_OBJECT_ID = p_quote_id;
2604: --debug_proc('ln_count = '||ln_count);
2605: IF (ln_count > 0) THEN -- The Subsidy pool is highest for this Quote