APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 210: FROM ahl_unit_config_headers

206: WHERE inventory_item_id = c_inventory_item_id
207: AND organization_id = c_organization_id;
208: CURSOR check_unit_instance(c_instance_id NUMBER) IS
209: SELECT csi_item_instance_id
210: FROM ahl_unit_config_headers
211: WHERE csi_item_instance_id = c_instance_id
212: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
213: CURSOR get_sub_unit_instance(c_instance_id NUMBER) IS
214: SELECT object_id

Line 217: FROM ahl_unit_config_headers

213: CURSOR get_sub_unit_instance(c_instance_id NUMBER) IS
214: SELECT object_id
215: FROM csi_ii_relationships
216: WHERE object_id IN (SELECT csi_item_instance_id
217: FROM ahl_unit_config_headers
218: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
219: START WITH subject_id = c_instance_id
220: AND relationship_type_code = 'COMPONENT-OF'
221: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)

Line 4364: l_unit_config_name ahl_unit_config_headers.name%TYPE;

4360: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || 'validate_instance' ;
4361:
4362: -- Added by jaramana on August 7, 2007 to support IB Trees
4363: l_unit_config_id NUMBER;
4364: l_unit_config_name ahl_unit_config_headers.name%TYPE;
4365: l_return_status VARCHAR2(1);
4366: l_dummy VARCHAR2(1);
4367:
4368: BEGIN

Line 5194: SELECT csi_item_instance_id FROM ahl_unit_config_headers

5190: FROM AHL_VISITS_B VST
5191: WHERE VST.VISIT_ID = c_visit_id;
5192:
5193: CURSOR uc_header_instance_csr(p_uc_header_id IN NUMBER) IS
5194: SELECT csi_item_instance_id FROM ahl_unit_config_headers
5195: WHERE unit_config_header_id = p_uc_header_id;
5196:
5197: l_task_instance_id NUMBER;
5198: l_visit_id NUMBER;

Line 5349: FROM ahl_unit_config_headers

5345: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
5346:
5347: CURSOR check_in_headers(c_instance_id NUMBER) IS
5348: SELECT csi_item_instance_id
5349: FROM ahl_unit_config_headers
5350: WHERE csi_item_instance_id = c_instance_id
5351: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
5352:
5353: TYPE objectid_tbl IS TABLE OF csi_ii_relationships.object_id%TYPE;