APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on AHL_MR_HEADERS_B

Line 517: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, AHL_MR_HEADERS_B AMHB

513: WHERE (STATUS_CODE IS NULL OR STATUS_CODE IN ('INIT-DUE', 'DEFERRED'))
514: AND UNIT_EFFECTIVITY_ID = x_unit_id;*/
515: /* For Bug# 3152532 fix by shbhanda dated 02-Dec-03*/
516: SELECT AUEB.MR_HEADER_ID
517: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, AHL_MR_HEADERS_B AMHB
518: WHERE AUEB.MR_HEADER_ID = AMHB.MR_HEADER_ID
519: AND AMHB.MR_STATUS_CODE = 'COMPLETE'
520: AND AMHB.VERSION_NUMBER IN
521: ( SELECT MAX(VERSION_NUMBER)

Line 522: FROM AHL_MR_HEADERS_B

518: WHERE AUEB.MR_HEADER_ID = AMHB.MR_HEADER_ID
519: AND AMHB.MR_STATUS_CODE = 'COMPLETE'
520: AND AMHB.VERSION_NUMBER IN
521: ( SELECT MAX(VERSION_NUMBER)
522: FROM AHL_MR_HEADERS_B
523: WHERE TITLE = AMHB.TITLE
524: AND TRUNC(SYSDATE)
525: BETWEEN TRUNC(EFFECTIVE_FROM)
526: AND TRUNC(NVL(EFFECTIVE_TO,SYSDATE+1))

Line 1110: FROM ahl_unit_effectivities_vl aueb, ahl_mr_headers_b amhb

1106: )
1107: IS
1108: CURSOR c_header (x_unit_id IN NUMBER) IS
1109: SELECT aueb.mr_header_id
1110: FROM ahl_unit_effectivities_vl aueb, ahl_mr_headers_b amhb
1111: WHERE aueb.mr_header_id = amhb.mr_header_id
1112: AND amhb.mr_status_code = 'COMPLETE'
1113: AND amhb.version_number IN
1114: (SELECT MAX(version_number)

Line 1115: FROM ahl_mr_headers_b

1111: WHERE aueb.mr_header_id = amhb.mr_header_id
1112: AND amhb.mr_status_code = 'COMPLETE'
1113: AND amhb.version_number IN
1114: (SELECT MAX(version_number)
1115: FROM ahl_mr_headers_b
1116: WHERE title = amhb.title
1117: AND TRUNC(SYSDATE)
1118: BETWEEN TRUNC(effective_from)
1119: AND TRUNC(NVL(effective_to,SYSDATE+1))

Line 1129: FROM ahl_unit_effectivities_vl aueb, ahl_mr_headers_b amhb

1125: --SKPATHAK :: Bug 8344789 :: 19-MAY-2009
1126: --Validate status and version of the MR associated to the SR
1127: CURSOR c_validate_mr (x_unit_id IN NUMBER) IS
1128: SELECT 'X'
1129: FROM ahl_unit_effectivities_vl aueb, ahl_mr_headers_b amhb
1130: WHERE aueb.mr_header_id = amhb.mr_header_id
1131: AND aueb.unit_effectivity_id = x_unit_id
1132: AND (amhb.version_number NOT IN
1133: ( SELECT MAX(version_number)

Line 1134: FROM ahl_mr_headers_b

1130: WHERE aueb.mr_header_id = amhb.mr_header_id
1131: AND aueb.unit_effectivity_id = x_unit_id
1132: AND (amhb.version_number NOT IN
1133: ( SELECT MAX(version_number)
1134: FROM ahl_mr_headers_b
1135: WHERE title = amhb.title
1136: AND TRUNC(SYSDATE)
1137: BETWEEN TRUNC(effective_from)
1138: AND TRUNC(NVL(effective_to,SYSDATE+1))

Line 1188: FROM AHL_MR_HEADERS_B AMHB, AHL_MR_RELATIONSHIPS_APP_V REL

1184: -- SKPATHAK :: Bug 9971127 :: 13-AUG-2010
1185: -- Added this cursor to validate if any of the child MR for a group MR are in TERMINATED status
1186: CURSOR c_validate_child_mrs (c_mr_header_id IN NUMBER) IS
1187: SELECT 'X'
1188: FROM AHL_MR_HEADERS_B AMHB, AHL_MR_RELATIONSHIPS_APP_V REL
1189: WHERE REL.MR_HEADER_ID = c_mr_header_id
1190: AND REL.RELATED_MR_HEADER_ID = AMHB.MR_HEADER_ID
1191: AND AMHB.MR_STATUS_CODE = 'TERMINATED'
1192: AND AMHB.VERSION_NUMBER IN

Line 1194: FROM AHL_MR_HEADERS_B

1190: AND REL.RELATED_MR_HEADER_ID = AMHB.MR_HEADER_ID
1191: AND AMHB.MR_STATUS_CODE = 'TERMINATED'
1192: AND AMHB.VERSION_NUMBER IN
1193: ( SELECT MAX(VERSION_NUMBER)
1194: FROM AHL_MR_HEADERS_B
1195: WHERE TITLE = AMHB.TITLE
1196: AND (MR_STATUS_CODE = 'COMPLETE' OR MR_STATUS_CODE = 'TERMINATED')
1197: );
1198: l_dummy1 c_validate_child_mrs%ROWTYPE;