[Home] [Help]
423: vp_assoc.end_date,
424: vp_assoc.assoc_object_type_code,
425: vp_assoc.assoc_object_id,
426: vp_assoc.assoc_object_version
427: FROM okl_vp_associations vp_assoc
428: ,okc_k_headers_b chr
429: ,okc_statuses_b sts
430: WHERE vp_assoc.chr_id = cp_chr_id
431: AND vp_assoc.chr_id = chr.id
438: vpa.end_date,
439: vpa.assoc_object_type_code,
440: vpa.assoc_object_id,
441: vpa.assoc_object_version
442: FROM okl_vp_associations vpa,
443: okl_vp_change_requests creq
444: WHERE creq.chr_id = cp_chr_id
445: AND vpa.crs_id = creq.id
446: AND creq.status_code in ('PASSED','NEW','INCOMPLETE');
453: vpa.end_date,
454: vpa.assoc_object_type_code,
455: vpa.assoc_object_id,
456: vpa.assoc_object_version
457: FROM okl_vp_associations vpa,
458: okl_vp_change_requests creq
459: WHERE vpa.crs_id = (select crs_id from okl_k_headers where id = cp_chr_id)
460: AND vpa.crs_id = creq.id
461: AND creq.status_code in ('PASSED','NEW','INCOMPLETE')
525: cp_start_date IN DATE,
526: cp_end_date IN DATE)IS
527: SELECT lat.name
528: FROM OKL_LEASEAPP_TMPLS lat,
529: okl_vp_associations_v vpa,
530: okc_k_headers_b chr,
531: okc_statuses_b sts
532: WHERE lat.id = vpa.assoc_object_id
533: AND chr.id = vpa.chr_id
547: )
548: UNION
549: SELECT lat.name
550: FROM OKL_LEASEAPP_TMPLS lat,
551: okl_vp_associations_v vpa,
552: okl_vp_change_requests chreq
553: WHERE lat.id = vpa.assoc_object_id
554: AND vpa.assoc_object_type_code = 'LA_TEMPLATE'
555: AND chreq.chr_id = cp_chr_id
567: AND chreq.status_code in ('PASSED','NEW','INCOMPLETE')
568: UNION
569: SELECT lat.name
570: FROM OKL_LEASEAPP_TMPLS lat,
571: okl_vp_associations_v vpa,
572: okl_vp_change_requests chreq,
573: okl_k_headers okl
574: WHERE lat.id = vpa.assoc_object_id
575: AND vpa.assoc_object_type_code = 'LA_TEMPLATE'