APPS.AHL_PRD_UTIL_PKG dependencies on AHL_MR_HEADERS_B

Line 549: AHL_MR_HEADERS_B

545: IS
546: SELECT
547: qa_inspection_type
548: FROM
549: AHL_MR_HEADERS_B
550: WHERE
551: mr_header_id = p_mr_header_id;
552:
553: /*

Line 1886: select UE.qa_collection_id, NVL(UE.qa_inspection_type,MR.qa_inspection_type) from ahl_unit_effectivities_b UE,ahl_mr_headers_b MR

1882: l_qa_status VARCHAR2(25);
1883: l_qa_insp_type VARCHAR2(25);
1884:
1885: CURSOR get_qa_info_csr(P_ue_id NUMBER) IS
1886: select UE.qa_collection_id, NVL(UE.qa_inspection_type,MR.qa_inspection_type) from ahl_unit_effectivities_b UE,ahl_mr_headers_b MR
1887: where UE.mr_header_id = MR.mr_header_id(+) and UE.unit_effectivity_id = P_ue_id;
1888:
1889: begin
1890: OPEN get_qa_info_csr(P_ue_id);