APPS.AHL_WARRANTY_CONTRACTS_PVT dependencies on AHL_UTIL_UC_PKG

Line 81: WHERE UCH.NAME = AHL_UTIL_UC_PKG.GET_UNIT_NAME(INSTANCE.INSTANCE_ID)

77: AND EXISTS
78: (
79: SELECT 'X'
80: FROM AHL_UNIT_CONFIG_HEADERS UCH
81: WHERE UCH.NAME = AHL_UTIL_UC_PKG.GET_UNIT_NAME(INSTANCE.INSTANCE_ID)
82: AND UCH.UNIT_CONFIG_STATUS_CODE IN ('INCOMPLETE', 'COMPLETE')
83: UNION ALL
84: SELECT 'X'
85: FROM dual

Line 86: WHERE AHL_UTIL_UC_PKG.GET_UNIT_NAME(INSTANCE.INSTANCE_ID) IS NULL);

82: AND UCH.UNIT_CONFIG_STATUS_CODE IN ('INCOMPLETE', 'COMPLETE')
83: UNION ALL
84: SELECT 'X'
85: FROM dual
86: WHERE AHL_UTIL_UC_PKG.GET_UNIT_NAME(INSTANCE.INSTANCE_ID) IS NULL);
87: -- avikukum :: changes for bug# 11664006 :: END;
88:
89: auto_create_details_rec auto_assign_item_instances_csr%ROWTYPE;
90: