APPS.AHL_UMP_UF_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 398: FROM ahl_unit_config_headers

394: l_unit_config_header_id NUMBER;
395:
396: CURSOR unit_config_header_id_csr(p_unit_name IN VARCHAR2) IS
397: SELECT unit_config_header_id
398: FROM ahl_unit_config_headers
399: WHERE name = p_unit_name;
400:
401: CURSOR uf_header_id_uid_csr(p_unit_config_header_id IN NUMBER) IS
402: SELECT uf_header_id

Line 568: FROM ahl_unit_config_headers UCH

564: l_use_unit_flag ahl_uf_headers.use_unit_flag%TYPE;
565:
566: CURSOR unit_status_check_csr(p_unit_config_header_id IN NUMBER) IS
567: SELECT UCH.unit_config_status_code
568: FROM ahl_unit_config_headers UCH
569: WHERE (UCH.active_end_date IS NULL OR TRUNC(UCH.active_end_date) > TRUNC(SYSDATE))
570: AND UCH.unit_config_header_id = p_unit_config_header_id;
571:
572: l_unit_config_status_code ahl_unit_header_details_v.unit_config_status_code%TYPE;

Line 1961: FROM ahl_unit_config_headers

1957: IS
1958: --
1959: CURSOR ahl_get_config_header_id_csr(c_unit_name IN VARCHAR2) IS
1960: SELECT unit_config_header_id
1961: FROM ahl_unit_config_headers
1962: WHERE name = c_unit_name;
1963: --
1964: CURSOR ahl_get_inv_item_id_csr(c_part_number IN mtl_system_items_kfv.concatenated_segments%TYPE) IS
1965: SELECT inventory_item_id

Line 1984: FROM csi_item_instances a, ahl_unit_config_headers b

1980: AND c.status = c_complete_status;
1981: --
1982: CURSOR ahl_item_id_from_uc_header_csr(c_uc_header_id IN NUMBER) IS
1983: SELECT a.inventory_item_id
1984: FROM csi_item_instances a, ahl_unit_config_headers b
1985: WHERE a.instance_id = b.csi_item_instance_id
1986: AND b.unit_config_header_id = c_uc_header_id;
1987: --
1988: CURSOR ahl_check_pc_id_csr(p_pc_node_id IN NUMBER,