APPS.AHL_MC_ITEMGROUP_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 809: FROM ahl_unit_config_headers unit, csi_item_instances csi

805: p_inventory_org_id IN NUMBER) IS
806: SELECT 'x'
807: FROM DUAL
808: WHERE EXISTS (SELECT name
809: FROM ahl_unit_config_headers unit, csi_item_instances csi
810: WHERE unit.csi_item_instance_id = csi.instance_id
811: AND master_config_id = p_relationship_id
812: AND TRUNC(SYSDATE) < TRUNC(NVL(unit.active_end_date, SYSDATE+1))
813: AND csi.inventory_item_id = p_inventory_item_id

Line 817: l_unitname ahl_unit_config_headers.name%TYPE;

813: AND csi.inventory_item_id = p_inventory_item_id
814: AND csi.last_vld_organization_id = p_inventory_org_id
815: );
816:
817: l_unitname ahl_unit_config_headers.name%TYPE;
818: l_unit_found BOOLEAN;
819: l_junk VARCHAR2(1);
820: BEGIN
821: -- initialize.