APPS.OKL_LEASE_QUOTE_SUBPOOL_PVT dependencies on OKL_LEASE_APPLICATIONS_B

Line 82: From OKL_LEASE_APPLICATIONS_B

78: BEGIN
79: --Begin -Updated the Select stmt with Count for bug#4723160 - varangan-8-11-2005
80: Select Count(1)
81: Into L_count
82: From OKL_LEASE_APPLICATIONS_B
83: WHERE LEASE_OPPORTUNITY_ID IS NOT NULL
84: AND ID = p_lease_app_id;
85:
86: IF (l_count = 0) THEN

Line 131: From OKL_LEASE_APPLICATIONS_B

127: l_parent_id Number := NULL;
128: l_is_parent VARCHAR2(3) := 'N';
129: CURSOR get_parent_laps IS
130: Select PARENT_LEASEAPP_ID
131: From OKL_LEASE_APPLICATIONS_B
132: WHERE ID = p_lease_app_id;
133:
134: CURSOR get_child_laps IS
135: SELECT 'Y'

Line 136: FROM OKL_LEASE_APPLICATIONS_B

132: WHERE ID = p_lease_app_id;
133:
134: CURSOR get_child_laps IS
135: SELECT 'Y'
136: FROM OKL_LEASE_APPLICATIONS_B
137: WHERE parent_leaseapp_id = p_lease_app_id;
138:
139: BEGIN
140: --is the lap having parent ?

Line 509: FROM OKL_LEASE_APPLICATIONS_B

505: IS
506: SELECT ID
507: , REFERENCE_NUMBER
508: , APPLICATION_STATUS
509: FROM OKL_LEASE_APPLICATIONS_B
510: WHERE application_Status NOT IN ('CANCELED','WITHDRAWN')
511: CONNECT BY PARENT_LEASEAPP_ID = PRIOR ID
512: START WITH ID = p_lap_id
513: UNION

Line 517: FROM OKL_LEASE_APPLICATIONS_B

513: UNION
514: SELECT ID
515: , REFERENCE_NUMBER
516: , APPLICATION_STATUS
517: FROM OKL_LEASE_APPLICATIONS_B
518: WHERE ID <> p_lap_id
519: AND application_Status NOT IN ('CANCELED','WITHDRAWN')
520: CONNECT BY PRIOR PARENT_LEASEAPP_ID = ID
521: START WITH ID = p_lap_id;

Line 540: OKL_LEASE_APPLICATIONS_B LAP

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
544: AND SUB.SUBSIDY_POOL_ID = SUB_POOL.ID

Line 572: OKL_LEASE_APPLICATIONS_B LAP

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
576: AND SUB.SUBSIDY_POOL_ID = SUB_POOL.ID

Line 1331: FROM OKL_LEASE_APPLICATIONS_B

1327: WHERE QUOTE.PARENT_OBJECT_ID = LEASEOPP.ID
1328: AND QUOTE.PARENT_OBJECT_CODE = 'LEASEOPP'
1329: AND QUOTE.STATUS = 'CT-ACCEPTED'
1330: AND LEASEOPP.ID = (SELECT LEASE_OPPORTUNITY_ID
1331: FROM OKL_LEASE_APPLICATIONS_B
1332: WHERE ID = p_leaseapp_id);
1333:
1334: ln_count NUMBER;
1335: ln_leaseopp_quote_id NUMBER;

Line 1593: FROM OKL_LEASE_APPLICATIONS_B

1589:
1590: --get the linked lease opportunity id
1591: SELECT LEASE_OPPORTUNITY_ID
1592: INTO lv_linked_lop_id
1593: FROM OKL_LEASE_APPLICATIONS_B
1594: WHERE ID =p_parent_object_id;
1595:
1596: --loop over all the subsidy pools used in this quote of lease appplication
1597: FOR l_get_leaseapp_pool_values IN c_get_leaseapp_pool_values LOOP