APPS.AHL_UMP_UNPLANNED_PVT dependencies on AHL_MR_HEADERS_B

Line 45: AHL_MR_HEADERS_B MRH

41: Cursor Chk_UE_Init_Due (c_mr_header_id NUMBER, c_instance_id NUMBER)
42: IS
43: SELECT 'x'
44: FROM AHL_UNIT_EFFECTIVITIES_B UE,
45: AHL_MR_HEADERS_B MRH
46: WHERE UE.mr_header_id = c_mr_header_id
47: AND MRH.mr_header_id = UE.mr_header_id
48: AND MRH.IMPLEMENT_STATUS_CODE IN ('MANDATORY','OPTIONAL_IMPLEMENT')
49: AND UE.csi_item_instance_id = c_instance_id

Line 101: FROM ahl_mr_headers_b M -- perf bug 6266738

97: WHERE EXISTS (SELECT r.related_mr_header_id
98: FROM ahl_mr_relationships r
99: WHERE r.mr_header_id = p_mr_header_id
100: AND EXISTS (SELECT m.mr_header_id
101: FROM ahl_mr_headers_b M -- perf bug 6266738
102: WHERE m.mr_header_id = r.related_mr_header_id
103: AND (m.version_number) in (SELECT max(M1.version_number)
104: from ahl_mr_headers_b M1
105: where M1.title = m.title -- perf bug 6266738

Line 104: from ahl_mr_headers_b M1

100: AND EXISTS (SELECT m.mr_header_id
101: FROM ahl_mr_headers_b M -- perf bug 6266738
102: WHERE m.mr_header_id = r.related_mr_header_id
103: AND (m.version_number) in (SELECT max(M1.version_number)
104: from ahl_mr_headers_b M1
105: where M1.title = m.title -- perf bug 6266738
106: AND m1.mr_status_code = 'COMPLETE'
107: AND SYSDATE between trunc(m1.effective_from)
108: and trunc(nvl(m1.effective_to,SYSDATE+1))

Line 272: FROM AHL_MR_HEADERS_B

268: IF (Chk_UE_Init_Due%FOUND) THEN
269: --pick the MR Title
270: SELECT title
271: INTO l_mr_title
272: FROM AHL_MR_HEADERS_B
273: WHERE mr_header_id = p_mr_header_id ;
274:
275: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_CANNOT_ADD_MRS');
276: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_mr_title);

Line 495: FROM AHL_MR_HEADERS_B

491: IF (Chk_UE_Init_Due%FOUND) THEN
492: --pick the MR Title
493: SELECT title
494: INTO l_mr_title
495: FROM AHL_MR_HEADERS_B
496: WHERE mr_header_id = l_appl_mrs_relns.RELATED_MR_HEADER_ID;
497: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_CANNOT_ADD_MRS');
498: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_mr_title);
499: FND_MSG_PUB.ADD;