APPS.AHL_UMP_SR_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 1111: FROM AHL_MR_HEADERS_APP_V

1107: UR.relationship_code = G_UE_PARENT_REL_CODE);
1108:
1109: CURSOR validate_mr_id_csr(p_mr_header_id IN NUMBER) IS
1110: SELECT TITLE, PROGRAM_TYPE_CODE
1111: FROM AHL_MR_HEADERS_APP_V
1112: WHERE MR_HEADER_ID = p_mr_header_id;
1113:
1114: CURSOR validate_instance_id_csr(p_csi_instance_id IN NUMBER) IS
1115: SELECT INSTANCE_NUMBER

Line 1659: WHERE UE.MR_HEADER_ID = (SELECT MR_HEADER_ID FROM AHL_MR_HEADERS_APP_V

1655: /* AMSRINIV : Bug 5208411 : Below Query Tuned */
1656:
1657: /* SELECT UE.UNIT_EFFECTIVITY_ID
1658: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE
1659: WHERE UE.MR_HEADER_ID = (SELECT MR_HEADER_ID FROM AHL_MR_HEADERS_APP_V
1660: WHERE MR_HEADER_ID like DECODE(p_mr_header_id, null, '%', p_mr_header_id) AND
1661: TITLE like DECODE(p_mr_header_id, null, p_mr_title, '%') AND
1662: VERSION_NUMBER like DECODE(p_mr_header_id, null, p_mr_version, '%')) AND
1663: VERSION_NUMBER like DECODE(p_mr_header_id, null, '' || p_mr_version || '', '%')) AND

Line 1677: FROM AHL_MR_HEADERS_APP_V

1673: SELECT UE.UNIT_EFFECTIVITY_ID
1674: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE
1675: WHERE UE.MR_HEADER_ID =
1676: (SELECT MR_HEADER_ID
1677: FROM AHL_MR_HEADERS_APP_V
1678: WHERE MR_HEADER_ID = NVL(p_mr_header_id,MR_HEADER_ID)
1679: AND TITLE like DECODE(p_mr_header_id, null, p_mr_title, '%')
1680: AND VERSION_NUMBER like DECODE(p_mr_header_id, null, '' || p_mr_version || '', '%')
1681: )

Line 1740: FROM AHL_MR_HEADERS_APP_V

1736:
1737: CURSOR get_mr_id_csr(p_mr_title IN VARCHAR2,
1738: p_mr_version IN NUMBER) IS
1739: SELECT MR_HEADER_ID
1740: FROM AHL_MR_HEADERS_APP_V
1741: WHERE UPPER(TITLE) = UPPER(p_mr_title) AND
1742: VERSION_NUMBER = p_mr_version;
1743:
1744: CURSOR get_csi_instance_id_csr(p_csi_instance_number IN VARCHAR2) IS