APPS.AHL_PRD_UTIL_PKG dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 273: AHL_UNIT_EFFECTIVITIES_B

269: IS
270: SELECT
271: csi_item_instance_id
272: FROM
273: AHL_UNIT_EFFECTIVITIES_B
274: WHERE
275: unit_effectivity_id = p_ue_id;
276:
277: -- declare all local variables here

Line 525: AHL_UNIT_EFFECTIVITIES_B

521: mr_header_id,
522: qa_collection_id,
523: qa_inspection_type
524: FROM
525: AHL_UNIT_EFFECTIVITIES_B
526: WHERE
527: unit_effectivity_id = p_ue_id;
528:
529: /*

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);