APPS.AHL_VWP_UNPLAN_TASKS_PVT dependencies on AHL_MR_HEADERS_B

Line 557: FROM AHL_MR_HEADERS_B AMHB, AHL_MR_RELATIONSHIPS_APP_V REL

553: --Cleaned up cxcheng 4-Aug-04
554: --Returns 1 level of child MRs
555: /* CURSOR get_child_mrs_csr(x_mr_id IN NUMBER) IS
556: SELECT REL.RELATED_MR_HEADER_ID
557: FROM AHL_MR_HEADERS_B AMHB, AHL_MR_RELATIONSHIPS_APP_V REL
558: WHERE REL.MR_HEADER_ID = x_mr_id
559: AND REL.RELATED_MR_HEADER_ID = AMHB.MR_HEADER_ID
560: AND AMHB.MR_STATUS_CODE = 'COMPLETE'
561: AND AMHB.VERSION_NUMBER IN

Line 563: FROM AHL_MR_HEADERS_B

559: AND REL.RELATED_MR_HEADER_ID = AMHB.MR_HEADER_ID
560: AND AMHB.MR_STATUS_CODE = 'COMPLETE'
561: AND AMHB.VERSION_NUMBER IN
562: ( SELECT VERSION_NUMBER
563: FROM AHL_MR_HEADERS_B
564: WHERE TITLE = AMHB.TITLE
565: AND TRUNC(SYSDATE) BETWEEN TRUNC(nvl(EFFECTIVE_FROM, sysdate-1)) AND
566: TRUNC(NVL(EFFECTIVE_TO,SYSDATE+1))
567: AND MR_STATUS_CODE = 'COMPLETE');

Line 587: from ahl_mr_headers_b

583: SELECT AMHV.TITLE
584: FROM AHL_VISIT_TASKS_B AVTB, AHL_MR_HEADERS_APP_V AMHV
585: WHERE AVTB.MR_ID = AMHV.MR_HEADER_ID
586: AND AVTB.MR_Id in (select mr_header_id
587: from ahl_mr_headers_b
588: where title in
589: (select title from ahl_mr_headers_b where mr_header_id = x_mr_id))
590: AND AVTB.INSTANCE_ID = x_serial_id
591: AND AVTB.VISIT_ID = x_id

Line 589: (select title from ahl_mr_headers_b where mr_header_id = x_mr_id))

585: WHERE AVTB.MR_ID = AMHV.MR_HEADER_ID
586: AND AVTB.MR_Id in (select mr_header_id
587: from ahl_mr_headers_b
588: where title in
589: (select title from ahl_mr_headers_b where mr_header_id = x_mr_id))
590: AND AVTB.INSTANCE_ID = x_serial_id
591: AND AVTB.VISIT_ID = x_id
592: AND (AVTB.STATUS_CODE IS NULL OR AVTB.STATUS_CODE not in ('CANCELLED','DELETED'));
593: