APPS.OKL_LEASEAPP_TEMPLATE_PVT dependencies on OKL_LEASEAPP_TEMPL_VERSIONS_B

Line 269: -- OKL_LEASEAPP_TEMPL_VERSIONS_B table

265: -- : lease application template.
266: --
267: -- Business Rules : this procedure is used to create lease application template
268: -- this procedure inserts records into the OKL_LEASEAPP_TEMPLATES and
269: -- OKL_LEASEAPP_TEMPL_VERSIONS_B table
270: --
271: -- Parameters :
272: -- Version : 1.0
273: -- History : 12-MAY-2005 SKGAUTAM created

Line 451: -- OKL_LEASEAPP_TEMPL_VERSIONS_B table.

447: -- : lease application template.
448: --
449: -- Business Rules : this procedure is used to update lease application template
450: -- this procedure updates records of the OKL_LEASEAPP_TEMPLATES and
451: -- OKL_LEASEAPP_TEMPL_VERSIONS_B table.
452: --
453: -- Parameters :
454: -- Version : 1.0
455: -- History : 12-MAY-2005 SKGAUTAM created

Line 506: okl_leaseapp_templ_versions_b lav

502: SELECT chr.START_DATE START_DATE
503: FROM okc_k_headers_b chr,
504: okl_vp_associations vpa,
505: Okl_Leaseapp_Templates lat,
506: okl_leaseapp_templ_versions_b lav
507: WHERE chr.scs_code = 'PROGRAM'
508: AND chr.sts_code = 'ACTIVE'
509: AND chr.id = vpa.chr_id
510: AND vpa.ASSOC_OBJECT_TYPE_CODE = 'LA_TEMPLATE'

Line 756: -- OKL_LEASEAPP_TEMPL_VERSIONS_B table

752: -- : lease application template.
753: --
754: -- Business Rules : this procedure is used to duplicate and version lease application template
755: -- this procedure inserts records into the OKL_LEASEAPP_TEMPLATES and
756: -- OKL_LEASEAPP_TEMPL_VERSIONS_B table
757: --
758: -- Parameters :
759: -- Version : 1.0
760: -- History : 13-MAY-2005 SKGAUTAM created

Line 803: , OKL_LEASEAPP_TEMPL_VERSIONS_B LAV

799: SELECT LAV.VERSION_NUMBER
800: , LAV.VALID_FROM
801: , LAV.VALID_TO
802: FROM OKL_LEASEAPP_TEMPLATES LAT
803: , OKL_LEASEAPP_TEMPL_VERSIONS_B LAV
804: WHERE LAT.ID = LAV.LEASEAPP_TEMPLATE_ID
805: AND LAT.ID = p_lat_id
806: AND TO_NUMBER(LAV.VERSION_NUMBER) = (SELECT MAX(TO_NUMBER(LAV1.VERSION_NUMBER))
807: FROM OKL_LEASEAPP_TEMPL_VERSIONS_B LAV1

Line 807: FROM OKL_LEASEAPP_TEMPL_VERSIONS_B LAV1

803: , OKL_LEASEAPP_TEMPL_VERSIONS_B LAV
804: WHERE LAT.ID = LAV.LEASEAPP_TEMPLATE_ID
805: AND LAT.ID = p_lat_id
806: AND TO_NUMBER(LAV.VERSION_NUMBER) = (SELECT MAX(TO_NUMBER(LAV1.VERSION_NUMBER))
807: FROM OKL_LEASEAPP_TEMPL_VERSIONS_B LAV1
808: WHERE LAV1.LEASEAPP_TEMPLATE_ID = LAT.ID);
809: --Fixed ssdeshpa Bug # 6487421 End
810: --asawanka bug 4966317 fix ends
811: BEGIN

Line 1136: -- OKL_LEASEAPP_TEMPL_VERSIONS_B table

1132: -- : lease application template.
1133: --
1134: -- Business Rules : this procedure is used to validate and update lease application template
1135: -- this procedure updates records of the OKL_LEASEAPP_TEMPLATES and
1136: -- OKL_LEASEAPP_TEMPL_VERSIONS_B table
1137: --
1138: -- Parameters :
1139: -- Version : 1.0
1140: -- History : 12-MAY-2005 SKGAUTAM created

Line 1401: okl_leaseapp_templ_versions_b lav

1397: SELECT chr.START_DATE START_DATE
1398: FROM okc_k_headers_b chr,
1399: okl_vp_associations vpa,
1400: Okl_Leaseapp_Templates lat,
1401: okl_leaseapp_templ_versions_b lav
1402: WHERE chr.scs_code = 'PROGRAM'
1403: AND chr.sts_code = 'ACTIVE'
1404: AND chr.id = vpa.chr_id
1405: AND vpa.ASSOC_OBJECT_TYPE_CODE = 'LA_TEMPLATE'

Line 1435: , OKL_LEASEAPP_TEMPL_VERSIONS_B LAV

1431: SELECT LAV.VERSION_NUMBER
1432: , LAV.VALID_FROM
1433: , LAV.VALID_TO
1434: FROM OKL_LEASEAPP_TEMPLATES LAT
1435: , OKL_LEASEAPP_TEMPL_VERSIONS_B LAV
1436: WHERE LAT.ID = LAV.LEASEAPP_TEMPLATE_ID
1437: AND LAT.ID = p_lat_id
1438: AND TO_NUMBER(LAV.VERSION_NUMBER) = (SELECT MAX(TO_NUMBER(LAV1.VERSION_NUMBER))
1439: FROM OKL_LEASEAPP_TEMPL_VERSIONS_B LAV1

Line 1439: FROM OKL_LEASEAPP_TEMPL_VERSIONS_B LAV1

1435: , OKL_LEASEAPP_TEMPL_VERSIONS_B LAV
1436: WHERE LAT.ID = LAV.LEASEAPP_TEMPLATE_ID
1437: AND LAT.ID = p_lat_id
1438: AND TO_NUMBER(LAV.VERSION_NUMBER) = (SELECT MAX(TO_NUMBER(LAV1.VERSION_NUMBER))
1439: FROM OKL_LEASEAPP_TEMPL_VERSIONS_B LAV1
1440: WHERE LAV1.LEASEAPP_TEMPLATE_ID = LAT.ID);
1441: --Fixed ssdeshpa Bug # 6487421 End
1442: --asawanka bug 4966317 fix ends
1443: BEGIN