APPS.AHL_UMP_SR_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 1077: FROM AHL_MR_HEADERS_APP_V

1073: UR.relationship_code = G_UE_PARENT_REL_CODE);
1074:
1075: CURSOR validate_mr_id_csr(p_mr_header_id IN NUMBER) IS
1076: SELECT TITLE, PROGRAM_TYPE_CODE
1077: FROM AHL_MR_HEADERS_APP_V
1078: WHERE MR_HEADER_ID = p_mr_header_id;
1079:
1080: CURSOR validate_instance_id_csr(p_csi_instance_id IN NUMBER) IS
1081: SELECT INSTANCE_NUMBER

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

1581: /* AMSRINIV : Bug 5208411 : Below Query Tuned */
1582:
1583: /* SELECT UE.UNIT_EFFECTIVITY_ID
1584: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE
1585: WHERE UE.MR_HEADER_ID = (SELECT MR_HEADER_ID FROM AHL_MR_HEADERS_APP_V
1586: WHERE MR_HEADER_ID like DECODE(p_mr_header_id, null, '%', p_mr_header_id) AND
1587: TITLE like DECODE(p_mr_header_id, null, p_mr_title, '%') AND
1588: VERSION_NUMBER like DECODE(p_mr_header_id, null, p_mr_version, '%')) AND
1589: VERSION_NUMBER like DECODE(p_mr_header_id, null, '' || p_mr_version || '', '%')) AND

Line 1603: FROM AHL_MR_HEADERS_APP_V

1599: SELECT UE.UNIT_EFFECTIVITY_ID
1600: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE
1601: WHERE UE.MR_HEADER_ID =
1602: (SELECT MR_HEADER_ID
1603: FROM AHL_MR_HEADERS_APP_V
1604: WHERE MR_HEADER_ID = NVL(p_mr_header_id,MR_HEADER_ID)
1605: AND TITLE like DECODE(p_mr_header_id, null, p_mr_title, '%')
1606: AND VERSION_NUMBER like DECODE(p_mr_header_id, null, '' || p_mr_version || '', '%')
1607: )

Line 1666: FROM AHL_MR_HEADERS_APP_V

1662:
1663: CURSOR get_mr_id_csr(p_mr_title IN VARCHAR2,
1664: p_mr_version IN NUMBER) IS
1665: SELECT MR_HEADER_ID
1666: FROM AHL_MR_HEADERS_APP_V
1667: WHERE UPPER(TITLE) = UPPER(p_mr_title) AND
1668: VERSION_NUMBER = p_mr_version;
1669:
1670: CURSOR get_csi_instance_id_csr(p_csi_instance_number IN VARCHAR2) IS