APPS.AHL_UMP_UTIL_PKG dependencies on AHL_MR_HEADERS_B

Line 249: FROM ahl_mr_headers_b

245:
246: -- cursor to get mr title, version and copy accomplishment.
247: CURSOR ahl_mr_headers_csr (p_mr_header_id IN NUMBER) IS
248: SELECT title mr_title, version_number, copy_accomplishment_flag
249: FROM ahl_mr_headers_b
250: WHERE mr_header_id = p_mr_header_id;
251:
252: -- cursor to get mr title, version and copy accomplishment.
253: CURSOR ahl_mr_title_csr (p_mr_title IN VARCHAR2,

Line 256: FROM ahl_mr_headers_b

252: -- cursor to get mr title, version and copy accomplishment.
253: CURSOR ahl_mr_title_csr (p_mr_title IN VARCHAR2,
254: p_version_number IN NUMBER) IS
255: SELECT version_number, copy_accomplishment_flag, mr_header_id
256: FROM ahl_mr_headers_b
257: WHERE title = p_mr_title AND
258: version_number = p_version_number;
259:
260: -- cursor to get accomplishments for current version.

Line 605: FROM AHL_MR_HEADERS_B b1, AHL_MR_HEADERS_B b2

601: SELECT distinct r.mr_header_id, r.related_mr_header_id,
602: r.relationship_code
603: FROM ahl_mr_relationships r
604: WHERE EXISTS (SELECT 'x'
605: FROM AHL_MR_HEADERS_B b1, AHL_MR_HEADERS_B b2
606: WHERE b1.mr_header_id = r.mr_header_id
607: AND b2.mr_header_id = r.related_mr_header_id
608: AND b1.mr_status_code = 'COMPLETE'
609: AND b2.mr_status_code = 'COMPLETE'

Line 624: AND exists (select 'x' from ahl_mr_headers_b mr1

620: r.relationship_code
621: FROM ahl_mr_relationships r
622: START WITH r.mr_header_id = p_mr_id
623: AND r.relationship_code = 'PARENT'
624: AND exists (select 'x' from ahl_mr_headers_b mr1
625: where mr1.mr_header_id = r.related_mr_header_id
626: and mr1.version_number = (select max(mr2.version_number)
627: from ahl_mr_headers_b mr2
628: where mr2.title = mr1.title

Line 627: from ahl_mr_headers_b mr2

623: AND r.relationship_code = 'PARENT'
624: AND exists (select 'x' from ahl_mr_headers_b mr1
625: where mr1.mr_header_id = r.related_mr_header_id
626: and mr1.version_number = (select max(mr2.version_number)
627: from ahl_mr_headers_b mr2
628: where mr2.title = mr1.title
629: and mr2.mr_status_code = 'COMPLETE'
630: and SYSDATE between trunc(mr2.effective_from)
631: and trunc(nvl(mr2.effective_to,SYSDATE+1))

Line 636: AND exists (select 'x' from ahl_mr_headers_b mr1

632: )
633: )
634: CONNECT BY r.mr_header_id = PRIOR r.related_mr_header_id
635: AND r.relationship_code = 'PARENT'
636: AND exists (select 'x' from ahl_mr_headers_b mr1
637: where mr1.mr_header_id = r.related_mr_header_id
638: and mr1.version_number = (select max(mr2.version_number)
639: from ahl_mr_headers_b mr2
640: where mr2.title = mr1.title

Line 639: from ahl_mr_headers_b mr2

635: AND r.relationship_code = 'PARENT'
636: AND exists (select 'x' from ahl_mr_headers_b mr1
637: where mr1.mr_header_id = r.related_mr_header_id
638: and mr1.version_number = (select max(mr2.version_number)
639: from ahl_mr_headers_b mr2
640: where mr2.title = mr1.title
641: and mr2.mr_status_code = 'COMPLETE'
642: and SYSDATE between trunc(mr2.effective_from)
643: and trunc(nvl(mr2.effective_to,SYSDATE+1))

Line 953: FROM ahl_mr_headers_b

949:
950: -- cursor to get mr title, version and copy accomplishment.
951: CURSOR ahl_mr_headers_csr (p_mr_header_id IN NUMBER) IS
952: SELECT title mr_title, version_number, copy_accomplishment_flag
953: FROM ahl_mr_headers_b
954: WHERE mr_header_id = p_mr_header_id;
955:
956: -- cursor to get mr title, version and copy accomplishment.
957: CURSOR ahl_mr_title_csr (p_mr_title IN VARCHAR2,

Line 960: FROM ahl_mr_headers_b

956: -- cursor to get mr title, version and copy accomplishment.
957: CURSOR ahl_mr_title_csr (p_mr_title IN VARCHAR2,
958: p_version_number IN NUMBER) IS
959: SELECT version_number, copy_accomplishment_flag, mr_header_id
960: FROM ahl_mr_headers_b
961: WHERE title = p_mr_title AND
962: version_number = p_version_number;
963:
964: -- cursor to get accomplishments for current version.