APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 208: FROM ahl_unit_config_headers

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

Line 215: FROM ahl_unit_config_headers

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

Line 3904: l_unit_config_name ahl_unit_config_headers.name%TYPE;

3900: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || 'validate_instance' ;
3901:
3902: -- Added by jaramana on August 7, 2007 to support IB Trees
3903: l_unit_config_id NUMBER;
3904: l_unit_config_name ahl_unit_config_headers.name%TYPE;
3905: l_return_status VARCHAR2(1);
3906: l_dummy VARCHAR2(1);
3907:
3908: BEGIN

Line 4734: SELECT csi_item_instance_id FROM ahl_unit_config_headers

4730: FROM AHL_VISITS_B VST
4731: WHERE VST.VISIT_ID = c_visit_id;
4732:
4733: CURSOR uc_header_instance_csr(p_uc_header_id IN NUMBER) IS
4734: SELECT csi_item_instance_id FROM ahl_unit_config_headers
4735: WHERE unit_config_header_id = p_uc_header_id;
4736:
4737: l_task_instance_id NUMBER;
4738: l_visit_id NUMBER;

Line 4889: FROM ahl_unit_config_headers

4885: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
4886:
4887: CURSOR check_in_headers(c_instance_id NUMBER) IS
4888: SELECT csi_item_instance_id
4889: FROM ahl_unit_config_headers
4890: WHERE csi_item_instance_id = c_instance_id
4891: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
4892:
4893: TYPE objectid_tbl IS TABLE OF csi_ii_relationships.object_id%TYPE;