APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on AHL_MR_HEADERS_B

Line 506: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, AHL_MR_HEADERS_B AMHB

502: WHERE (STATUS_CODE IS NULL OR STATUS_CODE IN ('INIT-DUE', 'DEFERRED'))
503: AND UNIT_EFFECTIVITY_ID = x_unit_id;*/
504: /* For Bug# 3152532 fix by shbhanda dated 02-Dec-03*/
505: SELECT AUEB.MR_HEADER_ID
506: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, AHL_MR_HEADERS_B AMHB
507: WHERE AUEB.MR_HEADER_ID = AMHB.MR_HEADER_ID
508: AND AMHB.MR_STATUS_CODE = 'COMPLETE'
509: AND AMHB.VERSION_NUMBER IN
510: ( SELECT MAX(VERSION_NUMBER)

Line 511: FROM AHL_MR_HEADERS_B

507: WHERE AUEB.MR_HEADER_ID = AMHB.MR_HEADER_ID
508: AND AMHB.MR_STATUS_CODE = 'COMPLETE'
509: AND AMHB.VERSION_NUMBER IN
510: ( SELECT MAX(VERSION_NUMBER)
511: FROM AHL_MR_HEADERS_B
512: WHERE TITLE = AMHB.TITLE
513: AND TRUNC(SYSDATE)
514: BETWEEN TRUNC(EFFECTIVE_FROM)
515: AND TRUNC(NVL(EFFECTIVE_TO,SYSDATE+1))

Line 1036: FROM ahl_unit_effectivities_vl aueb, ahl_mr_headers_b amhb

1032: )
1033: IS
1034: CURSOR c_header (x_unit_id IN NUMBER) IS
1035: SELECT aueb.mr_header_id
1036: FROM ahl_unit_effectivities_vl aueb, ahl_mr_headers_b amhb
1037: WHERE aueb.mr_header_id = amhb.mr_header_id
1038: AND amhb.mr_status_code = 'COMPLETE'
1039: AND amhb.version_number IN
1040: (SELECT MAX(version_number)

Line 1041: FROM ahl_mr_headers_b

1037: WHERE aueb.mr_header_id = amhb.mr_header_id
1038: AND amhb.mr_status_code = 'COMPLETE'
1039: AND amhb.version_number IN
1040: (SELECT MAX(version_number)
1041: FROM ahl_mr_headers_b
1042: WHERE title = amhb.title
1043: AND TRUNC(SYSDATE)
1044: BETWEEN TRUNC(effective_from)
1045: AND TRUNC(NVL(effective_to,SYSDATE+1))