APPS.AHL_UTIL_PC_PKG dependencies on AHL_UNIT_CONFIG_HEADERS

Line 74: FROM ahl_unit_config_headers

70: CONNECT BY parent_node_id = PRIOR pc_node_id
71: START WITH pc_node_id = p_pc_node_id)
72: AND unit_item_id IN (
73: SELECT Unit_config_header_ID
74: FROM ahl_unit_config_headers
75: WHERE Csi_Item_Instance_ID = p_Item_Instance_ID
76: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1)))
77: AND association_type_flag='U';
78:

Line 213: AHL_UNIT_CONFIG_HEADERS UNIT,

209: /*
210: SELECT DISTINCT
211: UNIT.UNIT_CONFIG_HEADER_ID
212: FROM
213: AHL_UNIT_CONFIG_HEADERS UNIT,
214: CSI_ITEM_INSTANCES CSI,
215: MTL_SYSTEM_ITEMS_KFV MTL,
216: AHL_PC_HEADERS_B HEADER
217: WHERE

Line 244: AHL_UNIT_CONFIG_HEADERS UNIT,

240: */
241: SELECT DISTINCT
242: UNIT.UNIT_CONFIG_HEADER_ID
243: FROM
244: AHL_UNIT_CONFIG_HEADERS UNIT,
245: CSI_ITEM_INSTANCES CSI,
246: MTL_SYSTEM_ITEMS_KFV MTL,
247: AHL_PC_HEADERS_B HEADER
248: WHERE