[Home] [Help]
90:
91: -- find out all objects with similar id (and optional version) which on the same association and with overlap dates
92: -- assoc_object_type would not make a difference here
93: CURSOR c_get_dup_obj_assoc (cp_object_id okl_vp_associations.assoc_object_id%TYPE
94: ,cp_crs_id okl_vp_change_requests.id%TYPE
95: ,cp_start_date okl_vp_associations.start_date%TYPE
96: ,cp_end_date okl_vp_associations.end_date%TYPE
97: ,cp_object_version okl_vp_associations.assoc_object_version%TYPE
98: ,cp_id okl_vp_associations.id%TYPE
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');
447: -- sjalasut, commented as the following sql is inconsequential
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')
462: */
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
556: AND vpa.crs_id = chreq.id
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'
576: AND okl.id = cp_chr_id