APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_MR_HEADERS_B

Line 1046: FROM AHL_MR_HEADERS_B

1042:
1043: CURSOR l_get_mr_id_csr(p_mr_title IN VARCHAR2,
1044: p_mr_version_number IN NUMBER) IS
1045: SELECT MR_HEADER_ID
1046: FROM AHL_MR_HEADERS_B
1047: WHERE TITLE = p_mr_title AND
1048: VERSION_NUMBER = p_mr_version_number;
1049:
1050: CURSOR l_get_item_instance_id_csr(p_instance_number IN VARCHAR2) IS

Line 1361: FROM ahl_unit_effectivities_b UE, ahl_mr_headers_b MR,

1357:
1358: -- For bug# 4172783.
1359: CURSOR l_ue_err_details_csr (p_ue_id IN NUMBER) IS
1360: SELECT CSI.instance_number, UE.due_date, MR.title
1361: FROM ahl_unit_effectivities_b UE, ahl_mr_headers_b MR,
1362: csi_item_instances CSI
1363: WHERE UE.unit_effectivity_id = p_ue_id
1364: AND UE.mr_header_id = MR.mr_header_id
1365: AND UE.csi_item_instance_id = CSI.instance_id;

Line 1402: l_err_title ahl_mr_headers_b.title%TYPE;

1398: l_prior_ue_status VARCHAR2(20);
1399:
1400: l_err_instance_number CSI_ITEM_INSTANCES.instance_number%TYPE;
1401: l_err_due_date DATE;
1402: l_err_title ahl_mr_headers_b.title%TYPE;
1403: l_err_serreq_num cs_incidents_all_b.incident_number%TYPE;
1404: l_service_line_id ahl_unit_effectivities_b.service_line_id%TYPE;
1405: -- added to validate visit status.
1406: l_visit_status VARCHAR2(100);

Line 3815: SELECT MR_HEADER_ID FROM AHL_MR_HEADERS_B

3811:
3812:
3813:
3814: CURSOR l_get_mr_header_id(p_mr_title IN VARCHAR2, p_version_number IN NUMBER) IS
3815: SELECT MR_HEADER_ID FROM AHL_MR_HEADERS_B
3816: WHERE TITLE = p_mr_title AND VERSION_NUMBER = p_version_number;
3817:
3818: CURSOR l_get_effective_to_date(p_mr_header_id IN NUMBER) IS
3819: SELECT EFFECTIVE_TO, application_usg_code FROM AHL_MR_HEADERS_VL WHERE MR_HEADER_ID = p_mr_header_id;

Line 3998: l_application_usg_code ahl_mr_headers_b.application_usg_code%TYPE;

3994: CONNECT BY ue_id = PRIOR related_ue_id
3995: AND relationship_code = 'PARENT';
3996:
3997: l_ue_descendent_rec l_ue_descendent_csr%ROWTYPE;
3998: l_application_usg_code ahl_mr_headers_b.application_usg_code%TYPE;
3999: l_junk varchar2(1);
4000: --l_req_id number;
4001:
4002: CURSOR get_mr_copy_dtls_csr(p_mr_header_id IN NUMBER) IS

Line 5414: FROM ahl_mr_headers_b mrh, ahl_mr_effectivities mre,

5410: AND status = 'COMPLETE';
5411:
5412: CURSOR get_mr_for_pc_csr (c_pc_header_id NUMBER) IS
5413: SELECT mrh.mr_header_id, mre.mr_effectivity_id
5414: FROM ahl_mr_headers_b mrh, ahl_mr_effectivities mre,
5415: ahl_pc_nodes_b pcn
5416: WHERE mrh.mr_header_id = mre.mr_header_id
5417: AND mre.pc_node_id = pcn.pc_node_id
5418: AND pcn.pc_header_id = c_pc_header_id