APPS.OKL_LEASE_QUOTE_SUBPOOL_PVT dependencies on OKL_LEASE_QUOTES_V

Line 525: FROM OKL_LEASE_QUOTES_V QUOTE

521: START WITH ID = p_lap_id;
522:
523: CURSOR c_get_quotesandoffers_in_lap(p_lease_app_id IN NUMBER) IS
524: SELECT QUOTE.ID QUOTE_ID
525: FROM OKL_LEASE_QUOTES_V QUOTE
526: WHERE QUOTE.STATUS IN ( 'PR-APPROVED','CT-ACCEPTED','CR-RECOMMENDATION')
527: AND QUOTE.ID <> p_current_qte_id
528: AND QUOTE.PARENT_OBJECT_CODE = 'LEASEAPP'
529: AND QUOTE.PARENT_OBJECT_ID = p_lease_app_id;

Line 539: OKL_LEASE_QUOTES_V QUOTE,

535: FROM OKL_COST_ADJUSTMENTS_B ADJ,
536: OKL_SUBSIDIES_B SUB,
537: OKL_SUBSIDY_POOLS_B SUB_POOL,
538: OKL_ASSETS_B ASSET,
539: OKL_LEASE_QUOTES_V QUOTE,
540: OKL_LEASE_APPLICATIONS_B LAP
541: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
542: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
543: AND ADJ.ADJUSTMENT_SOURCE_ID = SUB.ID

Line 558: FROM OKL_LEASE_QUOTES_V QUOTE

554: group by SUB.SUBSIDY_POOL_ID ,QUOTE.ID;
555:
556: CURSOR c_wd_get_quotesoffers_in_lap(p_lease_app_id IN NUMBER) IS
557: SELECT QUOTE.ID QUOTE_ID
558: FROM OKL_LEASE_QUOTES_V QUOTE
559: WHERE QUOTE.STATUS IN ( 'PR-APPROVED','CT-ACCEPTED','CR-RECOMMENDATION')
560: AND QUOTE.PARENT_OBJECT_CODE = 'LEASEAPP'
561: AND QUOTE.PARENT_OBJECT_ID = p_lease_app_id;
562:

Line 571: OKL_LEASE_QUOTES_V QUOTE,

567: FROM OKL_COST_ADJUSTMENTS_B ADJ,
568: OKL_SUBSIDIES_B SUB,
569: OKL_SUBSIDY_POOLS_B SUB_POOL,
570: OKL_ASSETS_B ASSET,
571: OKL_LEASE_QUOTES_V QUOTE,
572: OKL_LEASE_APPLICATIONS_B LAP
573: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
574: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
575: AND ADJ.ADJUSTMENT_SOURCE_ID = SUB.ID

Line 2221: FROM OKL_LEASE_QUOTES_V QUOTE

2217: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2218:
2219: CURSOR c_get_quotesandoffers_in_lap(p_lease_app_id IN NUMBER) IS
2220: SELECT QUOTE.ID QUOTE_ID
2221: FROM OKL_LEASE_QUOTES_V QUOTE
2222: WHERE QUOTE.STATUS IN ( 'PR-APPROVED','CT-ACCEPTED','CR-RECOMMENDATION')
2223: AND QUOTE.PARENT_OBJECT_CODE = 'LEASEAPP'
2224: AND QUOTE.PARENT_OBJECT_ID = p_lease_app_id;
2225: